Re: Times and dates in Oracle

You need to use a date mask with the to_date() function.

Eamonn Keating wrote:

> 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 - 12:07:27 CDT