[program-java] Re: SQL
- From: Don Raikes <DON.RAIKES@xxxxxxxxxx>
- To: program-java@xxxxxxxxxxxxx
- Date: Mon, 20 Oct 2008 21:23:12 +0000 (GMT)
Jim,
What database are you going against (not that that should make a difference,
but it might).
-----Original Message-----
From: Corbett, James [mailto:James.Corbett@xxxxxxxxxxxxx]
Sent: Monday, October 20, 2008 10:26 AM
To: Program-L (E-mail); Program-J (E-mail)
Subject: [program-java] SQL
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:
