What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND

Q

What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND? - Oracle DBA FAQ - Understanding SQL Basics

✍: FYIcenter.com

A

The main differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND are:

  • INTERVAL YEAR TO MONTH stores values as time intervals at the month level.
  • INTERVAL DAY TO SECOND stores values as time intervals at the fractional seconds level.

2007-04-24, 4708👍, 0💬