Home Forums SQL Server 7,2000 Globalization British and american date formats RE: British and american date formats

  • 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