• 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
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
Pie
Posts: 64717
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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")
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic