Skip to content

Instantly share code, notes, and snippets.

@jesusdomin

jesusdomin/gist:f7ba33609c02fa16704c

Created July 14, 2015 08:28
Show Gist options
  • Save jesusdomin/f7ba33609c02fa16704c to your computer and use it in GitHub Desktop.
Save jesusdomin/f7ba33609c02fa16704c to your computer and use it in GitHub Desktop.
Download ZIP
Utils Dates and Timestamp in Oracle
Raw
gistfile1.pls
-- Como obtener offset de timezone:
select tz_offset('US/Eastern') from dual;
-- Como obtener timestamp para una determinada zona horaria:
select (SYSTIMESTAMP AT TIME ZONE tz_offset('US/Eastern')) from dual;
-- Obtener date a partir de timestamp:
select CAST((SYSTIMESTAMP AT TIME ZONE tz_offset('US/Eastern')) AS DATE) from dual;
-- Date en formato unix:
select round((sysdate - date '1970-01-01') * 60 * 60 * 24) from dual;
-- Date en formato unix segun timezone:
select round((CAST((SYSTIMESTAMP AT TIME ZONE tz_offset('US/Eastern')) AS DATE) - date '1970-01-01') * 60 * 60 * 24) from dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment