Skip to content

Instantly share code, notes, and snippets.

@aristotll

aristotll/Num_Char_Date_Transfer_SQL

Forked from laoshuterry/Num_Char_Date_Transfer_SQL
Created October 11, 2016 08:58
Show Gist options
  • Save aristotll/dcb7b24656488313405abe0dbf0cb4fe to your computer and use it in GitHub Desktop.
Save aristotll/dcb7b24656488313405abe0dbf0cb4fe 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