Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need Script That Calc Hours Between 2 Dates
This seems to work:
SELECT TO_NUMBER( later_date - earlier_date) * 24
FROM table
/
Dan Navarro wrote:
> Does anyone have a script that calculates the difference between
> 2 dates in hours?
>
> Thanks in advance to anyone who can help ...
Received on Tue Apr 13 1999 - 17:43:51 CDT
![]() |
![]() |