*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "JSP and Oracle" Watch "JSP and Oracle" New topic
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: 9345
    
    2

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: http://aspose.com/file-tools
 
subject: JSP and Oracle
 
Similar Threads
Regular expression to take last word in a string
time conversion
Unparseable date exception....!!!!
Map 2 CMP Entity Beans to 1 table?
JDK malfunction