Thread: Is DATETIME an ANSI-SQL type?
Hi, Well the subject says it all: Can anyone tell me if DATETIME is an ANSI SQL type? TIA -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl
Joost Kraaijeveld wrote: > Hi, > > Well the subject says it all: > > 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 --Magne
Magne Mæhre <Magne.Mahre@Sun.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). regards, tom lane
Hi, On Tue, 2008-01-15 at 10:53 -0500, Tom Lane wrote: > Magne Mæhre <Magne.Mahre@Sun.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