I want to write a script to create a table which includes a date and time
field. How can this be done in oracle. When I do the following :
CREATE TABLE SPECAUD
PARTCODE VARCHAR2(12) ,
CHANGE_DATE DATE,
...
CONSTRAINT SPECAUD_PRIMARY_KEY PRIMARY KEY ( PARTCODE,CHANGE_DATE,REV_NO));
it will not allow me to enter a time value with the date field.
Also is it possible to create a field holding only the time
Any help in this regard would be greatly appreciated.
Eamonn
Received on Tue Aug 03 1999 - 11:34:16 CDT
