sort by time
Quick question for the pros.
I have a column in MS sql called time with values like:
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.
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!
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.
Originally Posted by russell
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)