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, 390👍, 0💬

Popular Posts:

Difference Between G...

What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...

sys.sql_modules - Ge...

How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...

Unicode Character St...

How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...

Using SELECT Stateme...

Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views...

Counting Rows with t...

How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...