Posts Tagged "date"

Calculate minutes between two dates

Simple question but always a pain in the ass in finding the right solution:

Read More
Determine the difference between two dates

Function created Now, i just create a view to demonstrate with: SQL> create or replace view temp_view   2  as   3  select to_date(’01-JAN-1999 12:02:04′, ‘dd-mon-yyyy hh24:mi:ss’ ) d1,   4         to_date(’15-MAR-1999 01:34:23′, ‘dd-mon-yyyy hh24:mi:ss’ ) d2   5  from

Read More