Re: Converting from epoch to timestamp?
- From: Stéphane Faroult <sfaroult@xxxxxxxxxxxx>
- To: gus.spier@xxxxxxxxx
- Date: Tue, 25 Jun 2013 18:23:25 +0200
Gus,
As far as I can remember, I have never seen anything but an ugly
to_date('19700101', 'YYYYMMDD') + :unix_timestamp / 86400
Not really implicit.
--
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
> I would have thought that somewhere deep in the bowels of all the ancestor
> versions of Oracle there would have been an implicit conversion of "epoch
> time" to DATE data type. If it is there, how would it be invoked?
> Regards,
>
> Gus
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
