=?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 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
