Showing posts with label Date and Time. Show all posts
Showing posts with label Date and Time. Show all posts

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

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,             ...