MS SQL Enterprise Manager Bug

Hi,

Using MS SQL Server 7. When I go into a table in design view and order by date created, it only orders on the day and not the date (Enterprise Manager) e.g.

29/08/1981, 11/12/2004, 31/12/2003

should be

11/12/2004
31/12/2003
29/08/1981

but it's this instead

31/12/2003
29/08/1981
11/12/2004

Please help.... is this a bug

presumably you meant order by date created descending

what is the datatype of the column?

i bet it's varchar, in which case the database is doing exactly what it should

I think the problem is the European date format (dd/mm/yyyy). MS products all sort on the American format (mm/dd/yyyy).

got news for ya

sql server stores datetimes as a pair of single integers

the only situation where the dates will sort differently is if you're sorting on a character string, in which case, yes, it does make a differenence whether the string is dd/mm/yyyy or mm/dd/yyyy