| Author |
JSP and Oracle
|
Ganapathy palanisamy
Greenhorn
Joined: May 29, 2008
Posts: 22
|
|
Dear Expert
I have daily_time table.
It has emp_id,Time_in ,Time_out,datex........
For each employee there will be Time_in ,Time_out .Some times Employee will be in Shift
Like Firstday evening 5 P.M he will be coming and next day morning he will be checking out.
My Example will be down here.
Empno Time_in Time_out Diff
1 18/AUG/2009 08:05:07 AM 18/AUG/2009 05:05:00 PM
IF THE EMPLOYEE IS IN SHIFT THEN
Empno Time_in Time_out Diff
1 17/AUG/2009 08:05:07 PM 18/AUG/2009 05:05:00 AM
Please help me to find diff between time_out - time_in
Diff should be in this format : HH:MM:SS
|
 |
Vikas Kapoor
Ranch Hand
Joined: Aug 16, 2007
Posts: 1374
|
|
You can do it on Java side or Database side.
On Java side, do you know Calendar API and Database side there is some function to format into required format.
What problem are you facing? What did you try? Errors?
|
|
Joe Harry
Ranch Hand
Joined: Sep 26, 2006
Posts: 8795
|
|
|
Use compareTo from the Date class in java.
|
SCJP 1.4, SCWCD 1.4 - Hints for you, SCBCD Hints - Demnachst, SCDJWS - Auch Demnachst
Did a rm -R / to find out that I lost my entire Linux installation!
|
|
 |
|
|
subject: JSP and Oracle
|
|
|
0
