[SQL] 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 ---(end of broadcast

Re: [SQL] Is DATETIME an ANSI-SQL type?

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

Re: [SQL] Is DATETIME an ANSI-SQL type?

=?ISO-8859-1?Q?Magne_M=E6hre?= [EMAIL PROTECTED] 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

Re: [SQL] Is DATETIME an ANSI-SQL type?

Hi, On Tue, 2008-01-15 at 10:53 -0500, Tom Lane wrote: =?ISO-8859-1?Q?Magne_M=E6hre?= [EMAIL PROTECTED] 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