Oracle_scripte/Tanel/unix2date.sql
2014-09-17 13:23:48 +02:00

6 lines
116 B
SQL

SELECT
to_char(to_date('01011970','ddmmyyyy') + 1/24/60/60 * &1, 'dd-Mon-yyyy hh24:mi:ss') "DATE"
FrOM DUAL
/