Skip to content

Instantly share code, notes, and snippets.

@cemremengu

cemremengu/excel-date.sql

Last active May 13, 2019 07:52
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 cemremengu/8b64e6a2982eeef44e751c8e692a00bd to your computer and use it in GitHub Desktop.
Save cemremengu/8b64e6a2982eeef44e751c8e692a00bd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
excel-date.sql
SELECT to_date('01/01/1900','DD/MM/YYYY') + NUMBER_OF_DAYS - 2 FROM DUAL
select * from INF_LR_POOL WHERE REGEXP_LIKE(POOL_ONAIR_DATE, '\d{5}')
UPDATE INF_UR_POOL SET POOL_ONAIR_DATE = to_char(to_date('01/01/1900','DD/MM/YYYY') + POOL_ONAIR_DATE - 2, 'YYYY-MM-DD')WHERE REGEXP_LIKE(POOL_ONAIR_DATE, '\d{5}')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment