Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Time function?
Here you go:
create or replace procedure TimeDiff
(FirstDate IN date
,SecondDate IN date ,Hours OUT number ,Minutes OUT number ,Seconds OUT number)
Seconds := mod(TotalSeconds, 60); Minutes := mod(TotalSeconds - Seconds, 3600) / 60; Hours := floor(TotalSeconds / 3600);
In article <7ic6vl$cu1$1_at_nnrp1.deja.com>,
grider22_at_my-dejanews.com wrote:
> Hi,
>
> Does anyone know of a function or how to create one that will take in
> two different time values and return the difference in hours, minutes
> and seconds as separate variables.
>
> Thanks
> Stephen
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 24 1999 - 14:37:52 CDT
![]() |
![]() |