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!

how to calculate the hour difference between two dates?

463428Feb 7 2006 — edited Feb 7 2006

hi all,
how to calculate the hour difference between two dates?

eg i trying this...

((TO_DATE(TO_CHAR(GRNi.reference_date_4,'hh24:mi'),'hh24:mi') -
TO_DATE(TO_CHAR(NVL(GRNi.reference_date_3,SYSDATE),'hh24:mi'),'hh24:mi'))*24)*60 Act_Hr

Reg.
AAK

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2006

Added on Feb 7 2006

5 comments

335 views