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
Showing posts with label Date and Time. Show all posts
Showing posts with label Date and Time. Show all posts
Monday, 25 May 2015
Subscribe to:
Posts (Atom)
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, ...
-
GL AND AP GL_CODE_COMBINATIONS AP_INVOICES_ALL code_combination_id = acct_pay_code_combination_id G...
-
Accounts Receivables useful information ACCOUNTS RECEIVABLES: ==================== ACCOUNTING METHOD , ACCRUAL OR CASH : So do you...
-
INVENTORY TRANSACTIONS : In oracle Applications, the hierarchy of org's is given below. Set of Books => Legal Entities => O...