From: | "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Magne Mæhre <Magne(dot)Mahre(at)Sun(dot)COM>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Is DATETIME an ANSI-SQL type? |
Date: | 2008-01-15 19:42:31 |
Message-ID: | 1200426151.19198.1.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
On Tue, 2008-01-15 at 10:53 -0500, Tom Lane wrote:
> =?ISO-8859-1?Q?Magne_M=E6hre?= <Magne(dot)Mahre(at)Sun(dot)COM> writes:
> > Joost Kraaijeveld wrote:
> >> Can anyone tell me if DATETIME is an ANSI SQL type?
>
> > No.
> > The Datetime types defined in SQL (ISO/IEC 9075:2003) are
>
> > DATE
> > TIME WITHOUT TIME ZONE
> > TIME WITH TIME ZONE
> > TIMESTAMP WITHOUT TIME ZONE
> > TIMESTAMP WITH TIME ZONE
>
> If you need to port from a system that used DATETIME as a type name,
> consider defining DATETIME as a domain over whichever of the standard
> types seems to have the closest semantics (likely the last of these).
Thanks for the confirmation and tips.
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-01-15 20:20:19 | Re: Update PK Violation |
Previous Message | Bryan Emrys | 2008-01-15 19:02:56 | SQL dealing with subquery comparison |