Time Data Type
From: Christopher Pisz <nospam_at_somewhere.com>
Date: Fri, 12 Jul 2002 09:22:15 GMT
Message-ID: <bdxX8.91984$p85.2476717_at_twister.austin.rr.com>
Date: Fri, 12 Jul 2002 09:22:15 GMT
Message-ID: <bdxX8.91984$p85.2476717_at_twister.austin.rr.com>
Hiyas,
I need to make a table with a column that
is a time like 00:45:00. I heard there was a Time
data type in SQL. Whats the syntax? There is nothing
about it in my textbook.
CREATE TABLE FLIGHT(
FLT_NUM NUMBER(3) PRIMARY KEY,
TOD NUMBER(4) NOT NULL,
FROM_AIRPT VARCHAR2(3),
TOA NUMBER(4) NOT NULL,
TO_AIRPT VARCHAR2(3),
FOREIGN KEY (FROM_AIRPT) REFERENCES AIRPORT,
FOREIGN KEY (TO_AIRPT) REFERENCES AIRPORT);
I need to change TOA and TOD to time. How?
Thanx,
Christopher
Received on Fri Jul 12 2002 - 11:22:15 CEST