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

Popular Posts:

How to measure functional software requirement specification (SRS) documents? Well, we need to defin...

How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce a...

How To Select All Columns of All Rows from a Table? - MySQL FAQs - SQL SELECT Query Statements with ...

Can we get a strongly typed resource class rather than using resource manager? In the previous quest...

How can we know the number of days between two given dates in PHP? Simple arithmetic: <?php $...