Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1 view
Skip to first unread message

devIT

unread,
May 2, 2020, 7:22:14 PM5/2/20
to
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.


Please visit this site:
http://dba.fyicenter.com/1000116_Differences_between_INTERVAL_YEAR_TO_MONTH_and_INTERVAL_DAY_TO_SECOND_in_Oracle.html

Thank you,
Team DBAFYI - DBA Resource Center
http://dba.fyicenter.com/
0 new messages