Oracle Query to calculate date difference in hours
Example: 1
SELECT floor(((to_date('01-jan-2012')-to_date('01-jun-2011'))*24*60*60)/3600) from dual;
Example 2:
Calculate diffence between any date from SYSDATE
Select trunc((Sysdate-to_date('06/19/2012 1:20:14','mm/dd/yyyy hh12:mi:ss'))*24) From dual;
Example: 1
SELECT floor(((to_date('01-jan-2012')-to_date('01-jun-2011'))*24*60*60)/3600) from dual;
Example 2:
Calculate diffence between any date from SYSDATE
Select trunc((Sysdate-to_date('06/19/2012 1:20:14','mm/dd/yyyy hh12:mi:ss'))*24) From dual;
No comments:
Post a Comment