sort by time

[Doc Thirst]

Quick question for the pros.

I have a column in MS sql called time with values like:

9:00 am
1:15 pm
3:00 pm
11:00 am

and so forth. No row having more then one time in this column. So when I recall this data I would like to sort by that column. Although it doesn't seem as though sql can apply a value to this data for sorting purposes. I'd imagine this is because of the mixed data types.

So what's the work around for this?

This is for a weekly schedule written in php.

Thanks for your time.

[chazzy]

are you storing it as a string?? i bet you're storing it as a string! if so, stop storing it as a string and it'll work!

[russell]

agreed. of course mssql 2k doesn't have a time data type, so you'll want to make it a smalldatetime

[Doc Thirst]

agreed. of course mssql 2k doesn't have a time data type, so you'll want to make it a smalldatetime

Oh hell, I bet you are right. Thanks (once) again, your all are my heros.