Home » SQL & PL/SQL » SQL & PL/SQL » Hours:MM:Seconds
Hours:MM:Seconds [message #230541] Thu, 12 April 2007 03:29 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: Hours:MM:Seconds [message #230553 is a reply to message #230541] Thu, 12 April 2007 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But you already post this a couple of days ago.
What's wrong with the previous answers?
Why don't you do on with the previous thread?

Regards
Michel
Re: Hours:MM:Seconds [message #230556 is a reply to message #230553] Thu, 12 April 2007 03:49 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
still today i am not getting the correct answer.pls advised me.,
regards
Re: Hours:MM:Seconds [message #230557 is a reply to message #230553] Thu, 12 April 2007 03:50 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Excellent point, Michel! Look Shahzad, it is not a good idea to start new threads all the time. Your original thread is already a merge of 4(yes FOUR!) threads on this subject. This one's closed. Continue in your other thread.

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

MHE

Previous Topic: objects permissions????
Next Topic: convert DataTypes
Goto Forum:
  


Current Time: Sat Dec 10 12:33:39 CST 2016

Total time taken to generate the page: 0.12450 seconds