In Microsoft SQL Server unfortunetly the only consistent date format is
YYYYMMDD, this is legacy from Sybase original code apparently; using
YYYY-MM-DD is converted as YYYY-DD-MM in many localised SQL Server
installs
(us_english is fine, other languages even British aren't).
What formats do other people use? Presumeably ISO 8601 (of course), but is
the normal consensus YYYYMMDD or the display friendly YYYY-MM-DD which we
cannot use reliably in SQL Server.
I guess my absolute question is - do most databases support YYYYMMDD so
when
it comes to portability there is no problems?
Background:
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/01/05/date-format-inconsistency-yyyy-mm-dd-or-yyyymmdd-when-2007-04-10-is-4th-october.aspx
Tony.
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
