|
日期轉UTC select (to_date('2013-04-09 14:02:15','yyyy-mm-dd hh24:mi:ss') - to_date('1970-01-01','yyyy-mm-dd'))*86400 from dual; UTC轉日期 select to_char(to_date(19700101,'yyyymmdd') + 1365516134.9/86400,'yyyymmddhh24miss') from dual; 時區(qū)查詢： SELECT SESSIONTIMEZONE FROM DUAL; select TZ_OFFSET(sessiontimezone) from dual; 帶時區(qū)的轉換： select TO_TIMESTAMP('19700101','yyyymmdd') + 1235728935/86400 +TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone),1,3))/24 from dual; select (to_date('2009-2-27 18:02:15','yyyy-mm-dd hh24:mi:ss') - to_date('1970-1-1','yyyy-mm-dd'))*86400- TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone),1,3))*3600 from dual 轉換過程中,，遇到時區(qū)問題,，檢查數(shù)據(jù)庫， select TZ_OFFSET(sessiontimezone) from dual; 所以直接在計算公式中加了８小時： select to_date(19700101,'yyyymmdd') + (1106796974.717+8*60*60)/86400 from dual 轉：http://www.cnblogs.com/neru/archive/2011/08/29/2157411.html |
|
|
