Skip to content

Instantly share code, notes, and snippets.

@gregseth

gregseth/oracle_to_date.sql

Last active August 12, 2019 09:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gregseth/6864399 to your computer and use it in GitHub Desktop.
Save gregseth/6864399 to your computer and use it in GitHub Desktop.
Download ZIP
Convert a number field standing for an unix timstamp, to a printable date with ORACLE.
Raw
oracle_to_date.sql
SELECT TO_CHAR(TO_DATE('19700101','YYYYMMDD') + date/86400, 'YYYY-MM-DD HH24:MI:SS') FROM a_table_with_a_column_named_date;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment