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.
Run the tidy code silently


Specific to Oracle
The type TIME is not supported - however there is an INTERVAL that might do instead.

Related links:

  • DATES