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

Popular Posts:

Managing Security, L...

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

Define External Tabl...

How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

SQL Server Transact-...

Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...

SQL Server Database ...

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