Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 73A2D2E3A33 for ; Tue, 15 Jan 2008 09:45:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 14265-04-3 for ; Tue, 15 Jan 2008 09:45:49 -0400 (AST) Received: from gmp-eb-mail-1.sun.com (gmp-eb-mail-1.sun.com [192.18.6.21]) by postgresql.org (Postfix) with ESMTP id 63EC62E3CAB for ; Tue, 15 Jan 2008 09:45:42 -0400 (AST) Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe1.eu.sun.com [192.18.6.10]) by gmp-eb-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m0FDjduk012964 for ; Tue, 15 Jan 2008 13:45:40 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0JUO00101TYU2U00@fe-emea-09.sun.com> (original mail from Magne.Mahre@Sun.COM) for pgsql-sql@postgresql.org; Tue, 15 Jan 2008 13:45:39 +0000 (GMT) Received: from [129.159.112.248] by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0JUO00IABU7W0640@fe-emea-09.sun.com>; Tue, 15 Jan 2008 13:45:36 +0000 (GMT) Date: Tue, 15 Jan 2008 14:45:31 +0100 From: =?ISO-8859-1?Q?Magne_M=E6hre?= Subject: Re: Is DATETIME an ANSI-SQL type? In-reply-to: <1200403108.27286.63.camel@panoramix.askesis.nl> To: Joost Kraaijeveld Cc: pgsql-sql@postgresql.org Message-id: <478CB8FB.5040600@sun.com> Organization: Sun Microsystems Inc. MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=iso-8859-1 Content-transfer-encoding: 7BIT References: <1200403108.27286.63.camel@panoramix.askesis.nl> User-Agent: Thunderbird 2.0.0.9 (X11/20071119) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/127 X-Sequence-Number: 29980 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