Re: Is DATETIME an ANSI-SQL type?

From: Magne Mæhre <Magne(dot)Mahre(at)Sun(dot)COM>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Is DATETIME an ANSI-SQL type?
Date: 2008-01-15 13:45:31
Message-ID: 478CB8FB.5040600@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Colin Wetherbee 2008-01-15 14:03:14 Re: JOIN a table twice for different values in the same query
Previous Message Magne Mæhre 2008-01-15 13:20:45 Re: JOIN a table twice for different values in the same query