OraFAQ Forum: Reports & Discoverer » Column formula Function required

Home » Developer & Programmer » Reports & Discoverer » Column formula Function required

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Column formula Function required [message #230545]

Thu, 12 April 2007 03:31

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

Report message to a moderator

Re: Column formula Function required [message #230770 is a reply to message #230545]

Thu, 12 April 2007 14:38

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: Column formula Function required [message #230843 is a reply to message #230770]

Fri, 13 April 2007 01:40

Maaher
Messages: 7065
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!

Closed.

MHE

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 01:47:56 CST 2024