Pablo Sanchez <pablo_at_dev.null> wrote in message news:<Xns930667140ED89pingottpingottbah_at_216.166.71.233>...
> Mike Sherrill <MSherrill_at_compuserve.com> wrote in
> news:ijag2vgtcjgi8mj3atitda98q6povuegta_at_4ax.com:
>
> > On Thu, 16 Jan 2003 14:35:08 -0600, Pablo Sanchez <pablo_at_dev.null>
> > wrote:
> >
> >>Which DBMS are you thinking about?
> >
> > Ones that conform to the SQL standard.
>
> Ahm, I was looking for a specific DBMS though. Can you list a
> commercially available DBMS that has this support?
>
ANSI/ISO 1999 Standard wrote:
There are three classes of datetime data types defined within this
part of ISO/IEC 9075:
-- DATE -- contains the <primary datetime field>s YEAR, MONTH, and
DAY.
-- TIME -- contains the <primary datetime field>s HOUR, MINUTE, and
SECOND.
-- TIMESTAMP -- contains the <primary datetime field>s YEAR, MONTH,
DAY, HOUR,
MINUTE, and SECOND.
(I do not have SQL-92 standard. But, I think they are basically same
as SQL-99 about timestamp data type.)
I think Oracle's date and timestamp and DB2's date, time and timestamp
conform to this standard.
Received on Fri Jan 17 2003 - 16:56:03 CST
