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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend