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
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.

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
Messages: 20850
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
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!



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: Sun Oct 23 21:04:38 CDT 2016

Total time taken to generate the page: 0.10040 seconds