Home » SQL & PL/SQL » SQL & PL/SQL » calculate hours:minutes:seconds (merged 4 cross-posts)
calculate hours:minutes:seconds (merged 4 cross-posts) [message #229261] Fri, 06 April 2007 04:57 Go to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
Oracle Verson: 8.0.5 For NT/2000 Enterprize Edition
Table Structure:
Field: DataType: Input Value:
Empcode Number(Cool
Intime: Varchar2(40)
22-Mar-2007 10:22:12
22-Mar-2007 14:32:22
Otime: Varchar2(40)
22-Mar-2007 13:01:42
22-Mar-2007 16:32:22

Please advised me, I want to calculate the exact hours:min:ss from the whole day which he has perform several type in/out.

Please send me a fuction, or procedure for database level handling, because I want to use it in Reports.

Regards.

Shahzad
Re: Calcluate the exact hours, minuts:sec [message #229275 is a reply to message #229261] Fri, 06 April 2007 07:13 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Why don't you show us what you have tried and why it didn't work or where you got stuck?
Re: Calcluate the exact hours, minuts:sec [message #229355 is a reply to message #229261] Fri, 06 April 2007 23:05 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
when i apllied this formiula in reports. it gives me error.
regards
Find Hours:minutes:Seconds [message #229358 is a reply to message #229261] Fri, 06 April 2007 23:12 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
Oracle Verson: 8.0.5 For NT/2000 Enterprize Edition
Table Structure:
Field: DataType: Input Value:
Empcode Number(Cool
Intime: Varchar2(40)
22-Mar-2007 10:22:12
22-Mar-2007 14:32:22
Otime: Varchar2(40)
22-Mar-2007 13:01:42
22-Mar-2007 16:32:22

Please advised me, I want to calculate the exact hours:min:ss from the whole day which he has perform several type in/out.

Please send me a fuction, or procedure for database level handling, because I want to use it in Reports.

Regards.

Shahzad
calcluate the eaxct hours :m,in for report [message #229360 is a reply to message #229261] Fri, 06 April 2007 23:33 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
Oracle Verson: 8.0.5 For NT/2000 Enterprize Edition
Table Structure:
Field: DataType: Input Value:
Empcode Number(
Intime: Varchar2(40)
22-Mar-2007 10:22:12
22-Mar-2007 14:32:22
Otime: Varchar2(40)
22-Mar-2007 13:01:42
22-Mar-2007 16:32:22

Please advised me, I want to calculate the exact hours:min:ss from the whole day which he has perform several type in/out.

Please send me a fuction, or procedure for database level handling, because I want to use it in Reports.

Regards.

Shahzad
Re: Find Hours:minutes:Seconds [message #229361 is a reply to message #229358] Fri, 06 April 2007 23:38 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
do NOT multi-post
Calcluate the exact hours, minuts:sec [message #229261]
Re: calcluate the eaxct hours :m,in for report [message #229362 is a reply to message #229360] Fri, 06 April 2007 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
do NOT multi-post
Calcluate the exact hours, minuts:sec [message #229261]
Re: Calcluate the exact hours, minuts:sec [message #229367 is a reply to message #229355] Sat, 07 April 2007 00:37 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
craftman1 wrote on Sat, 07 April 2007 06:05
when i apllied this formiula in reports. it gives me error.
regards


What formula?
What error?

[Updated on: Sat, 07 April 2007 00:37]

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229497 is a reply to message #229367] Mon, 09 April 2007 00:38 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
I mean in report Colum Formuila.
pls send me the procedure, or function from where i can get the required result.
regards
Report : HOurs:Minute:Second [message #229498 is a reply to message #229261] Mon, 09 April 2007 00:42 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
Report Help:
Oracle Verson: 8.0.5 For NT/2000 Enterprize Edition
Table Structure:
Field: DataType: Input Value:
Empcode Number(
Intime: Varchar2(40)
22-Mar-2007 10:22:12
22-Mar-2007 14:32:22
Otime: Varchar2(40)
22-Mar-2007 13:01:42
22-Mar-2007 16:32:22
Coulmnn Formula????

Please advised me, I want to calculate the exact hours:min:ss from the whole day which he has perform several type in/out.

Please send me a fuction, or procedure for database level handling, because I want to use it in Reports.

Regards.
Re: Calcluate the exact hours, minuts:sec [message #229531 is a reply to message #229497] Mon, 09 April 2007 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select to_timestamp('22-Mar-2007 13:01:42','DD-Mon-YYYY HH24:MI:SS')
  2         - to_timestamp('22-Mar-2007 10:22:12','DD-Mon-YYYY HH24:MI:SS')
  3  from dual;
TO_TIMESTAMP('22-MAR-200713:01:42','DD-MON-YYYYHH24:MI:SS')-TO_TIMESTAMP('2
---------------------------------------------------------------------------
+000000000 02:39:30.000000000

1 row selected.
Re: Report : HOurs:Minute:Second [message #229534 is a reply to message #229498] Mon, 09 April 2007 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

See my answer the other place you post it.

Regards
Michel
Re: Calcluate the exact hours, minuts:sec [message #229542 is a reply to message #229531] Mon, 09 April 2007 02:03 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
wether this command (timestamp) is applicable in Oracle 8.0.5 version advised?
regards
Re: Calcluate the exact hours, minuts:sec [message #229545 is a reply to message #229542] Mon, 09 April 2007 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, missed your version.
But you missed the answers in other posts of the same kind of questions these last days.

Regards
Michel
Re: Calcluate the exact hours, minuts:sec [message #229562 is a reply to message #229531] Mon, 09 April 2007 02:29 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
sir
i am asking about the to_timestamp function. when i applied this query.it gives me error??
pls advised if this to_timestam,p command is included in oracle version 8.
regards
Re: Calcluate the exact hours, minuts:sec [message #229566 is a reply to message #229545] Mon, 09 April 2007 02:36 Go to previous messageGo to next message
craftman1
Messages: 15
Registered: April 2007
Location: Pakistan
Junior Member
but i have mention in my previouse post.?
pls check it? and send me the newtes code?/?
regards
Re: Calcluate the exact hours, minuts:sec [message #229578 is a reply to message #229566] Mon, 09 April 2007 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you have and this is why I said:
Quote:
Sorry, missed your version.

And now, I also said:
Quote:
you missed the answers in other posts of the same kind of questions these last days.


So search a little bit and you'll find the answer for version that don't know timestamp.

Regards
Michel
Re: Report : HOurs:Minute:Second [message #229602 is a reply to message #229498] Mon, 09 April 2007 06:32 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Now STOP crossposting. Continue in your original thread.
Previous Topic: UTL_TCP package
Next Topic: distinct values of more than one column
Goto Forum:
  


Current Time: Fri Dec 02 16:35:12 CST 2016

Total time taken to generate the page: 0.39105 seconds