SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference in minutes for two timestamp values

614945Apr 12 2012 — edited Apr 17 2012

Dear All,

I am having two timestamp values and need to calculate the total time in minutes between them and store in a variable.
Can you please help me.

Eg:

T1 = 12-APR-12 06.01.56.000000 AM
T2 = 10-APR-12 06.14.32.000000 AM

I want to have T3 as the total time difference beteween T1 and T2 in minutes.
Not able to convert +000000001 23:47:24.000000000 in minutes
The above value I got was by just substracting T1 and T2

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2012

Added on Apr 12 2012

8 comments

30,627 views