Re: Time Data Type

Look in the manual. specifically the SQL reference manual; I believe the answer is in the beginning of the manual where it enumerates all the data types and talks about each one.

Jim
"Christopher Pisz" <nospam_at_somewhere.com> wrote in message news: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 - 16:35:51 CEST