[program-java] SQL
- From: "Corbett, James" <James.Corbett@xxxxxxxxxxxxx>
- To: "Program-L (E-mail)" <Program-L@xxxxxxxxxxxxx>, "Program-J (E-mail)" <program-java@xxxxxxxxxxxxx>
- Date: Mon, 20 Oct 2008 13:26:14 -0400
Sorry for the cross post.
I have a table in a database that contains a string representation of times
captured in a 24 hour clock.
I.E. 1.09, 14:59, 13:09, 4:09
I retrieve them like this:
strSQL = Select * from table where date = date ordered by sTime.
Result: 4:09, 14:59, 13:09, 1:09....
It appears that the order by clause is doing something unexpected. Any ideas,
and no I can't change the database.
Jim
James M. Corbett
GST Division (Micro Applications)
Acting CS3 IT Specialist / Acting Team Leader
(613) 941-1338
"I love deadlines. I like the whooshing sound they make as they fly by."
Douglas Adams
"I'm Jim Corbett and I approve this message"
Other related posts:
