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
2020-04-14, 910👍, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...