How To Write Date and Time Literals

Q

How To Write Date and Time Literals? - Oracle DBA FAQ - Understanding SQL Basics

✍: FYIcenter.com

A

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

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

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

2007-04-24, 4287👍, 0💬