unix epoch time to oracle time

最新推荐文章于 2022-06-24 15:02:07 发布

cmkl71919

最新推荐文章于 2022-06-24 15:02:07 发布

阅读量130

点赞数

文章标签：数据库 php

Our billing system date format is using unix epoch time.

converison like the following:

oracle time --&gt unix epoch time
select (sysdate - to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')) * 86400 - substr(TZ_OFFSET(sessiontimezone),1,instr(TZ_OFFSET(sessiontimezone),':')-1) * 3600 from dual;

unix epoch time--&gtoracle time
select from_tz(cast(to_date('1970-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS') as timestamp),'Australia/NSW') at local + numtodsinterval(1305882706,'SECOND') from dual;

you can find your own timezone from here: select distinct tzname from V$TIMEZONE_NAMES;

The easiest way, just use this webpage to convert: http://www.4webhelp.net/us/timestamp.php?action=stamp&stamp=1305917878&timezone=10

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26719/viewspace-1050144/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26719/viewspace-1050144/