OraFAQ Forum: SQL & PL/SQL » calculate hours:minutes:seconds (merged 4 cross-posts)

Home » SQL & PL/SQL » SQL & PL/SQL » calculate hours:minutes:seconds (merged 4 cross-posts)

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

calculate hours:minutes:seconds (merged 4 cross-posts) [message #229261]

Fri, 06 April 2007 04:57

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

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

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229275 is a reply to message #229261]

Fri, 06 April 2007 07:13

skooman
Messages: 913
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?

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229355 is a reply to message #229261]

Fri, 06 April 2007 23:05

craftman1
Messages: 15
Registered: April 2007
Location: Pakistan

Junior Member

when i apllied this formiula in reports. it gives me error.
regards

Report message to a moderator

Find Hours:minutes:Seconds [message #229358 is a reply to message #229261]

Fri, 06 April 2007 23:12

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

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

Report message to a moderator

calcluate the eaxct hours :m,in for report [message #229360 is a reply to message #229261]

Fri, 06 April 2007 23:33

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

Report message to a moderator

Re: Find Hours:minutes:Seconds [message #229361 is a reply to message #229358]

Fri, 06 April 2007 23:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

do NOT multi-post
Calcluate the exact hours, minuts:sec [message #229261]

Report message to a moderator

Re: calcluate the eaxct hours :m,in for report [message #229362 is a reply to message #229360]

Fri, 06 April 2007 23:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

do NOT multi-post
Calcluate the exact hours, minuts:sec [message #229261]

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229367 is a reply to message #229355]

Sat, 07 April 2007 00:37

Frank
Messages: 7901
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

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 message to a moderator

Report : HOurs:Minute:Second [message #229498 is a reply to message #229261]

Mon, 09 April 2007 00:42

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.

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229531 is a reply to message #229497]

Mon, 09 April 2007 01:44

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Report : HOurs:Minute:Second [message #229534 is a reply to message #229498]

Mon, 09 April 2007 01:49

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

See my answer the other place you post it.

Regards
Michel

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229542 is a reply to message #229531]

Mon, 09 April 2007 02:03

craftman1
Messages: 15
Registered: April 2007
Location: Pakistan

Junior Member

wether this command (timestamp) is applicable in Oracle 8.0.5 version advised?
regards

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229545 is a reply to message #229542]

Mon, 09 April 2007 02:06

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229562 is a reply to message #229531]

Mon, 09 April 2007 02:29

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

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229566 is a reply to message #229545]

Mon, 09 April 2007 02:36

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

Report message to a moderator

Re: Calcluate the exact hours, minuts:sec [message #229578 is a reply to message #229566]

Mon, 09 April 2007 04:26

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Report : HOurs:Minute:Second [message #229602 is a reply to message #229498]

Mon, 09 April 2007 06:32

Frank
Messages: 7901
Registered: March 2000

Senior Member

Now STOP crossposting. Continue in your original thread.

Report message to a moderator

Previous Topic:	UTL_TCP package
Next Topic:	distinct values of more than one column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 16:53:40 CST 2024