Groups | Search | Server Info | Login | Register

Groups > md.jobs > #58

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

Newsgroups md.jobs
Date 2020-05-02 16:24 -0700
Message-ID <c1f8a858-755b-4657-b8a5-8718b0afb79f@googlegroups.com> (permalink)
Subject What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle?
From dev IT <devoct2009@yahoo.com>

Show all headers | View raw

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/

Back to md.jobs | Previous | Next | Find similar

Thread

What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle? dev IT <devoct2009@yahoo.com> - 2020-05-02 16:24 -0700

csiph-web