File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes JSP and Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "JSP and Oracle" Watch "JSP and Oracle" New topic

JSP and Oracle

Ganapathy palanisamy

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
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: 10032

Use compareTo from the Date class in java.

SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
I agree. Here's the link:
subject: JSP and Oracle
It's not a secret anymore!