Oracle SQL - What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND

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

What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND? - Oracle DBA FAQ - Understanding SQL Basics

✍: FYIcenter.com

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.

2007-04-24, 4708👍, 0💬

Popular Posts:

Once I have developed the COM wrapper do I have to still register the COM in registry? Yes.

What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump ...

Where Is the Submitted Form Data Stored? - PHP Script Tips - Processing Web Forms When a user submit...

How To Use SELECT Statement to Count the Number of Rows? - Oracle DBA FAQ - Understanding SQL SELECT...

How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...