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, 1606🔥, 0💬
Popular Posts:
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...