Re: How to compute for Oracle Date using seconds elapsed since midnight?

Buyatkik wrote:
>
> Hi,
>
> Would someone be able to tell me how to compute the Oracle date for this
> value. This value is in seconds elapsed since... I also do not know what
> the base date for the computation will be. Is there something like
> DateAdd("s", 904892400, BaseDate)
>
> Thanks

        Date := SysDate + (Seconds / 86400);         

        Orace dates store dates as whole days, plus a fraction indication seconds past midnight.

-- 
	Thomas Jones-Low		JobScheduler for Oracle
	tjoneslo_at_softstart.com		
	Ph: 802-652-1596		http://www.softstart.com