About Time
Hi Everyone,
I need a PLSQL query inorder to keep track of TIME.
Scenario : The Time Performed should be before the Other Time.
Regards,
Pet
Software/Hardware used:
OC
I need a PLSQL query inorder to keep track of TIME.
Scenario : The Time Performed should be before the Other Time.
Regards,
Pet
Software/Hardware used:
OC
ASKED:
October 27, 2009 6:03 AM
UPDATED:
October 27, 2009 2:29 PM
Answer Wiki:
A lot more info is needed...
There are so many date / time functions available. Also are you taking inputs directly or selecting from tables?
Here are a few to get you started:
SELECT TO_DATE('01/01/1900 00:59:59','mm/dd/yy hh24:mi:ss')
, SYSDATE
, to_char(sysdate, 'HH:MM:SS')
, TO_CHAR(SYSDATE + 1/(24*60*60),'HH24:MI:SS')
from dual;
day_elapsed := 24*EXTRACT(DAY from (time_out - time_in));
hr_elapsed := EXTRACT(HOUR from (time_out - time_in));
min_elapsed := ROUND(1.6667*EXTRACT(MINUTE from (time_out - time_in)),0);
time_elapsed := TO_NUMBER((day_elapsed + hr_elapsed) || '.' || min_elapsed);
SELECT (time_out - time_in) Time_performed
, time_in
, time_out
from xx_table
Add details to the discussion and maybe we can be more specific
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
