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