Time and Timestamp

[shyamal]

As oracle 8i only has a date datatype for conversions such as SQL how does one input time and timestamp into oracle?

Thanks in advance.

 

[carp]

By using the DATE datatype:

INSERT INTO my_time_table
VALUES to_date('25 December 2001 23:18:15','DD Month YYYY HH24:MI:SS');

 

[carp]

Although if you're timestamping stuff, SYSDATE will do the job with a lot less typing:

INSERT INTO my_table(timestamp_column,...) VALUES (sysdate,...);