Home » Developer & Programmer » Reports & Discoverer » Column formula Function required
Column formula Function required [message #230545] Thu, 12 April 2007 03:31 Go to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
i wan to calcluate the HOurs:MM:SS from diffrent types:
Fields: Datatype:
Itime: Varchar2(40)
Otime: Varchar23(40)
Date: Date
........suppose one employee has in/out 3-4 times a day. now we wan to calcluate the exact no of hours:Minuts:Seconds for his work day.pls let me know how it is possible.
i am using Oracle version: 8.0.5 Enter prize Editon.
ur urgent reply will be appiricated.
regards

Re: Column formula Function required [message #230770 is a reply to message #230545] Thu, 12 April 2007 14:38 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
1) If possible, get rid of bad design -> do not store DATE (time) values into the CHARACTER column.

Search OraFAQ forum for "time difference". This is a recent topic about (almost) the same problem.

2) Subtract all pairs of OUT time and IN time
3) Sum those times
4) Return the result

Re: Column formula Function required [message #230843 is a reply to message #230770] Fri, 13 April 2007 01:40 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Oh no you won't start another thread on this subject!

Wasn't this thread enough? I already closed this one. That would make -at least- 6 (SIX!) threads for ONE problem. What are you trying to prove?

One last time: continue in your original (merged 4 cross post) thread!

http://www.orafaq.com/forum/fa/448/0/

Closed.

MHE
Previous Topic: How can I create the dynamic column for the report
Next Topic: How to pass our Form output to a table when we click pushbutton
Goto Forum:
  


Current Time: Thu Dec 08 22:01:28 CST 2016

Total time taken to generate the page: 0.08973 seconds