Basic Oracle Concepts and Programming Question:
Download Questions PDF

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

Answer:

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.


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
What Are the Differences between DATE and TIMESTAMP in Oracle?What Are the Differences between BLOB and CLOB in Oracle?