Convert a stored UNIX-Timestamp

[huhu333]

Hi,
we have stored an UNIX-Timestamp as Number. Is there any way to convert this UNIX-Timestamp in an human readable Date directly on the Oracle SQLPlus Prompt.

 

[sdamle]

Here is the script:

SELECT to_char(new_time( to_date('01011970','ddmmyyyy') + 1/24/60/60 * <the number>,
'GMT', 'EDT' ), 'dd-mon-yyyy hh24:mi:ss' )
from dual

 

[huhu333]

thanks
this was exactly what i needed.