Re: Is DATETIME an ANSI-SQL type?

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