SELECT EXTRACT( DAY FROM INTERVAL '5 02:30:20.11' DAY TO SECOND )FROM dual;
SELECT EXTRACT( Hour FROM INTERVAL '5 02:30:20.11' DAY TO SECOND )FROM dual;
SELECT EXTRACT( Hour FROM INTERVAL '04:30:20.11' Hour TO SECOND )FROM dual;
SELECT EXTRACT( Minute FROM INTERVAL '30:20.11' Minute TO SECOND )FROM dual;
SELECT EXTRACT(Minute FROM INTERVAL '5 04:32:20.11' DAY TO SECOND )FROM dual;
SELECT EXTRACT(Second FROM INTERVAL '5 04:30:20.11' DAY TO SECOND )FROM dual;
----------------------------------------------------------------------------------------------------
SELECT EXTRACT( Minute FROM INTERVAL '59' Minute )FROM dual;
SELECT EXTRACT( Day FROM INTERVAL '30' DAY )FROM dual;
SELECT EXTRACT( Hour FROM INTERVAL '04' Hour )FROM dual;
SELECT EXTRACT( Second FROM INTERVAL '20.11' SECOND )FROM dual;
----------------------------------------------------------------------------
Interval day to second video link:
[ Ссылка ]
Check this link to know Till now what i covered topics in oracle
[ Ссылка ]

свернуть