Home Forums SQL Server 7,2000 Globalization British and american date formats RE: British and american date formats
Andy sql
SSCrazy Eights
Points: 9483
More actions
July 14, 2008 at 9:13 am
#842459
There is some debate about the "best" way to represent the date. With MS SQL, probably best to go with ISO 8601 format:
yyyy-mm-ddThh:mm:ss
where "T" is the separator between the date and time.
eg. 2008-07-14T17:06:55