Re: Q: Date/time arithmetics with Oracle Server

There are 86400 seconds in a day. To add or subtract seconds use + or - n/86400 where n is number of seconds.

• alton

Uwe Schneider wrote:

> Hi experts,
>
> is there an easy way to add or subtract a number of seconds to/from an
> Oracle date type such as
>
> ADD_SECONDS(date_val,-20)
>
> without using special packages???
>
> In my opinion the Oracle DATE type is quite strange.
>
> Best regards!
> --
> uwe.schneider_at_xlink.net
Received on Fri Jun 25 1999 - 12:00:28 CDT