What Are the Differences between DATE and TIMESTAMP

Q

What Are the Differences between DATE and TIMESTAMP? - Oracle DBA FAQ - Understanding SQL Basics

✍: 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.

2007-04-24, 4345👍, 0💬