Re: How to create date directly from UNIX time

On Jan 10, 9:28 am, krivenok.dmi..._at_gmail.com wrote:
> Hello All!
>
> How can I create object of DATE type directly from UNIX time?
> to_date doesn't provide this facility.
>
> I want to avoid unnecessary strftime call in my perl script.
> Any suggestions?
>
> Thanks!

Just add to_date('01-01-1970', 'dd-mm-yyyy') to your Unix time. That should be all.

-- 
Sybrand Bakker
Senior Oracle DBA