[cfaussie] Re: Sorting by 24 hr time

[Spike]

Depending on your database, you will probably have some sort of cast 
function that will allow you to turn the string field into date/time, or 
number in the select statement. You can then sort on the converted 
column value.

Spike

Knott, Brian wrote:

Does anyone know how to sort a query based on a 24 hour time.  The field in
question is a test field not time field.  At the moment it is sorting like
this
13:00
06:00
10:00
11:00
Mot sure why it want to put 13:00 above the rest

Brian Knott
QANTM Studio
Senior Database Developer
Ph (07) 30174331
Mob 0407572127
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/

 

--
Stephen Milligan
Consultant for hire
http://www.spike.org.uk


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/