SQL Server 2000 Order By Date

[aconybeare]

Hi,

Think I might have a solution

CONVERT(VARCHAR(23),GETDATE(),126) 

--Outputs YYYY-MON-DDTHH:MM:SS.MMM(24H) FORMAT

Cheers Al