General MySQL Oracle SQL Server

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, 3485🔥, 0💬

General MySQL Oracle SQL Server