Postgres Pro
Downloads
Home   >   mailing lists

Re: Is DATETIME an ANSI-SQL type? - Mailing list pgsql-sql

From Magne Mæhre
Subject Re: Is DATETIME an ANSI-SQL type?
Date
Msg-id 478CB8FB.5040600@sun.com
Whole thread Raw
In response to Is DATETIME an ANSI-SQL type?  ("Joost Kraaijeveld" <J.Kraaijeveld@Askesis.nl>)
Responses Re: Is DATETIME an ANSI-SQL type?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Magne Mæhre
Date:
Subject: Re: JOIN a table twice for different values in the same query
Next
From: Colin Wetherbee
Date:
Subject: Re: JOIN a table twice for different values in the same query