File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 » Databases » JDBC and Relational Databases
Bookmark "JSP and oracle" Watch "JSP and oracle" New topic

JSP and oracle

Ganapathy palanisamy

Joined: May 29, 2008
Posts: 22

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

Joined: Jan 10, 2002
Posts: 63866

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] [About Bear] [Books by Bear]
Peter Johnson

Joined: May 14, 2008
Posts: 5852

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
I agree. Here's the link:
subject: JSP and oracle
It's not a secret anymore!