Date and Time Literals in Oracle


How To Write Date and Time Literals in Oracle?



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

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

SELECT TIMESTAMP '1997-01-31 09:26:50.124' FROM DUAL
31-JAN-97 AM
-- This is ANSI format


Date and Time Interval Literals in Oracle

Numeric Literals in Oracle

Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-04-14, 1405👍, 0💬