SQLzoo.net

Date and time types.

Oracle
The SQL standard permits three types. DATE, TIME and TIMESTAMP. A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose.	Execute tidy up code silently DROP TABLE t_dttest CREATE TABLE t_dttest( a DATE, c TIMESTAMP); INSERT INTO t_dttest VALUES ( DATE '1962-05-20', TIMESTAMP '1962-05-20 10:32:16'); SELECT * FROM t_dttest;
Specific to Oracle
The type TIME is not supported - however there is an INTERVAL that might do instead.