Skip to content

Instantly share code, notes, and snippets.

@laoshuterry

laoshuterry/Num_Char_Date_Transfer_SQL

Created October 2, 2016 10:54
Show Gist options
  • Save laoshuterry/95fce7bc81a8b9135afdca5b70d70de6 to your computer and use it in GitHub Desktop.
Save laoshuterry/95fce7bc81a8b9135afdca5b70d70de6 to your computer and use it in GitHub Desktop.
Download ZIP
工作中4类常用时间转换
Raw
Num_Char_Date_Transfer_SQL
NUM2CHAR := SELECT TO_CHAR(TO_DATE('19700101080000','yyyyMMddHH24miss')+((3684394329-2208988800)/86400), 'yyyyMMddHH24miss')FROM DUAL
CHAR2NUM := SELECT (TO_date('20160901000000'char,'yyyyMMddHH24miss') - to_date('19700101080000','yyyymmddhh24miss'))*86400+2208988800 FROM DUAL
DATE2NUM := SELECT (sysdate - to_date('19700101080000','yyyymmddhh24miss'))*86400+2208988800 FROM DUAL;
NUM2DATE := SELECT TO_DATE('19700101080000','yyyyMMddHH24miss')+((3684394329-2208988800)/86400) FROM DUAL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment