JSP and Oracle

[Ganapathy palanisamy]

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]

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 San]

Use compareTo from the Date class in java.