Oracle - Differences between DATE and TIMESTAMP in Oracle

Differences between DATE and TIMESTAMP in Oracle

Q

What Are the Differences between DATE and TIMESTAMP in Oracle?

✍: FYIcenter.com

A

The main differences between DATE and TIMESTAMP are:

DATE stores values as century, year, month, date, hour, minute, and second.
TIMESTAMP stores values as year, month, day, hour, minute, second, and fractional seconds.

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 191👍, 0💬

Popular Posts:

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

Passing Values to St...

How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

DDL (Data Definition...

What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...