How to correctly convert a date value from NUMBER to CHAR?

Question

Oracle

Hello.
In the Oracle database, in the schemas, the date is written in the NUMBER format,
example 1467290851.
How to correctly convert the date value from NUMBER to CHAR?

Answer 1

What do you need? From unixtime to receive a normal type of date? If yes, then you can

select to_char(to_date('01.01.1970 00:00:00','dd.mm.yyyy hh24:mi:ss') + 1/24/60/60 * :unixtime, 'dd.mm.yyyy hh24:mi:ss') from dual;

Answer 2

Found a solution

(date '1970-01-01' + 3/24 + LAST_MODIFIED_DATE /60/60/24)