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, 2119🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...