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, 5413👍, 0💬

Popular Posts:

Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...

How To Concatenate Two Character Strings? - MySQL FAQs - Introduction to SQL Basics If you want conc...

Should synchronization primitives be used on overrided bean methods? No. The EJB specification speci...

How To Enter Microseconds in SQL Statements? - MySQL FAQs - Introduction to SQL Date and Time Handli...

What does address of operator do in background? The AddressOf operator creates a delegate object to ...