Oracle Database Interview Question:

How To Write Date and Time Literals in Oracle?

Submitted by: Administrator

Date and time literals can coded as shown in the following samples:

SELECT DATE '2002-10-03' FROM DUAL -- ANSI date format
03-OCT-07

SELECT TIMESTAMP '0227-01-31 09:26:50.124' FROM DUAL
31-JAN-07 09.26.50.124000000 AM
-- This is ANSI format

Submitted by: Administrator