Re: [INTERFACES] Access'97 and ODBC

On Thu, 30 Apr 1998, The Hermit Hacker wrote:

> On Thu, 30 Apr 1998, Jose' Soares Da Silva wrote:
>
> > On 30 Apr 1998, Tom Ivar Helbekkmo wrote:
> >
> > > "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it> writes:
> > >
> > > > I vote for changing default date format to ISO-8601 to reflect
> > > > PostgreSQL documentation and for adherence to Standard SQL92.
> > >
> > > Hear! Hear! Good standards beat silly conventions any day!
> > >
> > Seems that you don't like conventions Tom, but you want
> > that all world use dates with American format.
> > Seems that you want impose one convention.
>
> Can someone inform me of what ISO-8601 exactly is?
>

- ISO 8601:1988, Data elements and interchange formats - Information
interchange-Representation of dates and times.

3.1.2 Definitions taken from ISO 8601

This International Standard makes use of the following terms
defined in ISO 8601:

a) Coordinated Universal Time (UTC)
b) date ("date, calendar" in ISO 8601)

See (Second Informal Review Draft) ISO/IEC 9075:1992,
Database Language SQL- July 30, 1992)

The required ISO 8601 syntax for DATE is:

DATE 'YYYY-MM-DD'

Comments:

1) DATE combines the datetime fields YEAR, MONTH and DAY.

2) DATE defines a set of correctly formed values that
represent any valid Gregorian calendar date between January 1, 1
AD and December 31, 9999 AD.

3) Any operation that attempts to make a DATE <data type>
contain a YEAR value that is less than 1 or greater than 9999
will fail; the DBMS will return the:
SQLSTATE error 22007 "data exception-invalid datetime format".

4) DATE expects dates to have the following form: yyyy-mm-dd
e.g.: 1994-07-15 represents July 15, 1994.
5) DATE has a length of 10.
6) Date literals must start with the <keyword> DATE and
include 'yyyy-mm-dd';
e.g.:

CREATE mytable (mydate DATE);
INSERT INTO mytable (mydate) VALUES (DATE '1996-01-01');

Jose'