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
Subscribe to:
Post Comments (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...
-
SELECT hou.name Organization_name, ---------------------- --Customer Information ---------------------- ...
No comments:
Post a Comment