Discover Top Posts Tagged with #extract function

Data function and format in oracle

Date function and format in Oracle

NUMTODSINTERVAL: Difference in dates with result in DAYS, HOURS, MINUTE and SECONDS -- You can do it by callculaation SELECT TRUNC( difference ) AS days, TRUNC( MOD( difference * 24, 24 ) ) AS hours, TRUNC( MOD( difference * 24*60, 60 ) ) AS minutes, TRUNC( MOD( difference * 24*60*60, 60 ) ) AS seconds FROM ( SELECT TO_DATE( '2018-01-02 01:01:12', 'YYYY-MM-DD…