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
-
Colin Wetherbee wrote:
Colin Wetherbee wrote:
Phillip Smith wrote:
As a side note - all the IATA codes are unique for each airport -
wouldn't it be better to use these as the Primary Key and Foreign
Keys? Then you wouldn't have to even join the tables unless you
wanted the port names (not just