Skip to content

Instantly share code, notes, and snippets.

@flinox

flinox/get_date_from_unix_epoch_value.sql

Created February 25, 2019 20:24
Show Gist options
  • Save flinox/aa2e9ccc01d5186b213e0a3c9a7f6fd5 to your computer and use it in GitHub Desktop.
Save flinox/aa2e9ccc01d5186b213e0a3c9a7f6fd5 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle: Get the date from a unix epoch value
Raw
get_date_from_unix_epoch_value.sql
select to_date('19700101','YYYYMMDD') + ( 1 / 24 / 60 / 60 / 1000) * <value_unix_epoch> from dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment