Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Order By problem

When I say to sort on a datetime field on descending order, the date is sorted. However, the time difference is not reflected in the results.
Any way, we can fix it.
i.e. If I have two records with the same dates but different times, the sorting order is not considering the time.
[298 byte] By [rkbnair] at [2007-11-11 8:18:26]
# 1 Re: Order By problem
What kind of database?
Phil Weber at 2007-11-11 23:47:12 >
# 2 Re: Order By problem
Sorry. It is SQL Server 2000
rkbnair at 2007-11-11 23:48:09 >
# 3 Re: Order By problem
Are you absolutely certain the column type is DateTime? Can you post your SQL statement?
pclement at 2007-11-11 23:49:08 >