Collections:
Date and Time Literals in Oracle
How To Write Date and Time Literals in Oracle?
✍: FYIcenter.com
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
⇒ Date and Time Interval Literals in Oracle
2020-04-14, 1405👍, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Query Multiple Tables Jointly in MySQL? If you want to query information stored in multiple t...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...