Monday, 25 May 2015

Difference Between date in Time formate

SELECT FLOOR ( ( (sysdate - (sysdate-1)) * 24 * 60 * 60) / 3600)          || ' HOURS ' ||
           FLOOR((((sysdate - (sysdate-1))*24*60*60) -
           FLOOR(((sysdate - (sysdate-1))*24*60*60)/3600)*3600)/60)
           || ' MINUTES ' ||
           ROUND((((sysdate - (sysdate-1))*24*60*60) -
           FLOOR(((sysdate - (sysdate-1))*24*60*60)/3600)*3600 -
           (FLOOR((((sysdate - (sysdate-1))*24*60*60) -
           FLOOR(((sysdate - (sysdate-1))*24*60*60)/3600)*3600)/60)*60) ))
          || ' SECS ' time_difference from dual

No comments:

Post a Comment

Query to Find Receipt Class and its GL Combinition Query

SELECT ARC.NAME ReceiptClass,        ARC.CREATION_METHOD_CODE Creation_Mehthod,        DECODE (ARC.REMIT_METHOD_CODE,             ...