Re: ASP > SQL date problem!?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: CJM (cjmnews04_at_newsgroups.nospam)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 17:36:58 +0100

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:OWpWAWOkEHA.548@TK2MSFTNGP11.phx.gbl...
>
> Wron. SQL Server will also accept the ISO standard date:
>
> YYYYMMDD
>
>

I agree with your advice, Bob, but I'm uneasy about the use of the word
'Standard'.

ISO 8601 states that the standard date format is YYYY-MM-DD, but then goes
on the explain that other delimiters are acceptable as is their omission.

So YYYYMMDD, YYYY-MM-DD and YY-MM-DD are all 'standard' date formats that
meet the ISO 8601 requirements. If you add a time element, as is often
important in DB work then you have further variations still, eg.
YYYY-MM-DDTHH:MM:SS.

Unfortunately, different DB's only accept a subset of the valid formats! So
there's often no way to code some SQL that is truly portable.

Further reading:
RFC3339
ISO8601
etc...

Not quite as straightforward as it should be, perhaps?

Chris

Relevant Pages

  • Re: ASP > SQL date problem!?
    ... SQL Server will also accept the ISO standard date: ... ISO 8601 states that the standard date format is YYYY-MM-DD, ... different DB's only accept a subset of the valid formats! ...
    (microsoft.public.access.adp.sqlserver)
  • Re: man -t odd page size
    ... > ISO compliant document whereas a small minority benefits from having non ... theory shouldn't the FreeBSD lists, docs and code all be in Chinese? ... A4 isn't a DIN standard anymore, ...
    (freebsd-questions)
  • Re: Pixel policy
    ... Or Class Anything compliant? ... If the class is not clearly mentioned the ISO ... According to the ISO standard all LCD screens are sold as Class 1 ... screens unless it is stated clearly and prominently that they are not. ...
    (uk.tech.digital-tv)
  • Re: Why are Digital camera images made wrong?
    ... proportion as usually not as pleasing as the metric paper ratio - it's ... It is an ISO size, but does not divide neatly by 10. ... The international paper size standard, ISO 216, is based on the German DIN 476 standard for paper sizes. ... Successive paper sizes in the series A1, A2, A3, etc., are defined by halving the preceding paper size parallel to its shorter side. ...
    (alt.photography)
  • Re: UTF-8 Erkennung
    ... ISO 8859-1 und ISO-8859-1? ... Charset-Bezeichner dürfen nämlich keine Leerzeichen enthalten. ... Alias: ISO-8859-1 ... Diese Belegung der Steuerzeichen nach ECMA-48, insbesondere die Control-Sets C0 und C1, setzte sich aber zumindest im Computerbereich als Standard tatsächlich durch. ...
    (de.comp.lang.java)