Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP and Oracle

 
Ganapathy palanisamy
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1374
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10122
3
Eclipse IDE Mac PPC Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use compareTo from the Date class in java.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic