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.

 

Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle

Differences between NUMBER and BINARY_FLOAT in Oracle

Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-04-25, 4037🔥, 0💬