Oracle - Date and Time Literals in Oracle

Date and Time Literals in Oracle

Q

How To Write Date and Time Literals in Oracle?

✍: FYIcenter.com

A

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

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 402👍, 0💬

Popular Posts:

What Is Open Databas...

What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...

SQL Server Database ...

Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

BEGIN ... END Statem...

How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...

CONVERT() - Converti...

How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...