Home Forums SQL Server 7,2000 T-SQL What is the Best Way for Comparing Datetime value in SQLSERVER 2000? RE: What is the Best Way for Comparing Datetime value in SQLSERVER 2000?

  • This proves how ambigous these dateformats with delimiters are, and how easy they can be misread.

    And you show in your other post how easy it can be to get the wrong dates when relying on the delimited formats.

    When I wrote 01/02/03, I intended it to be 1st of February 2003.. or maybe 3rd of February in 2001 (as the Japanese notation would suggest)

    The one and only style that holds up against language and datesettings is ISO (style 112) yyyymmdd

    ...my .02 anyway

    =;o)

    /Kenneth