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

Q

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

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

 

Differences between BLOB and CLOB in Oracle

Differences between DATE and TIMESTAMP in Oracle

Understanding SQL Language Basics for Oracle

⇑⇑ Oracle Database Tutorials

2020-04-25, 1890🔥, 0💬