Re: Converting from epoch to timestamp?

From: St�phane Faroult <sfaroult_at_roughsea.com>
Date: Tue, 25 Jun 2013 18:23:25 +0200
Message-ID: <51C9C3FD.6090504_at_roughsea.com>

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

>

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>




--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 25 2013 - 18:23:25 CEST

This message: [ Message body ]
Next message: Uzzell, Stephan: "RE: 12c appears to be available on https://edelivery.oracle.com"
Previous message: Amaral, Rui: "RE: 12c appears to be available on https://edelivery.oracle.com"
In reply to: Gus Spier: "Converting from epoch to timestamp?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message