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, 1684🔥, 0💬
Popular Posts:
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...