wood burning stoves 2.0*
The moose likes JDBC 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 » Databases » JDBC
Bookmark "JSP and oracle" Watch "JSP and oracle" New topic
Author

JSP and oracle

Ganapathy palanisamy
Greenhorn

Joined: May 29, 2008
Posts: 22
I AM WORKING OUT WITH JSP AND ORACLE


query for calculating the time difference in hours with minutes. From these columns shift1,in_punch1,out_punch1 and shift2 ,in_punch2,out_punch2 in oracle?

(WHERE EMPCODE='7010001' AND PUNCH_DATE='01-JAN-10' ; for the whole month of employee..)

i did this query for a single shift but not for both the shift.

select ((to_date(OUT_PUNCH1,'HH24:MI:SS')-to_date(IN_PUNCH1,'HH24:MI:SS'))*24)-8 from act_stipend;

where as 24 for gives whole hours in days and 8 gives extra hours worked beyond 8 hours.

kindly do the help for me.
thank you.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60789
    
  65

Please take the time to choose the correct forum for your posts. This forum is for questions on XYZ. For more information, please read this.

This post has been moved to a more appropriate forum.

Also,pPlease be sure to take the time to compose descriptive subjects for your posts; read this for more information.

A title such as "ORACLE 10G" is not helpful. What would happen if all posts had such a title?

Please go back and change your post to add a more meaningful subject by clicking the button on your post.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

The new title is not much better. Think: what are you asking about? Isn't it how to write a query to do time differences? Then why not make that the title? ("Oracle query for time difference")


JBoss In Action
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JSP and oracle
 
Similar Threads
Prepared Statement and Date class
Oracler Date function
Resultset based on current Date and Time
Prepared Statement and Date class - Problem still exists
Difference between two timestamp fields