oracle time

最新推荐文章于 2024-04-30 22:32:31 发布

jis117

最新推荐文章于 2024-04-30 22:32:31 发布

阅读量103

点赞数

分类专栏： sql oracle 文章标签：数据库

本文链接：https://blog.csdn.net/jis117/article/details/84533203

版权

sql 同时被 2 个专栏收录

12 篇文章 0 订阅

订阅专栏

oracle

8 篇文章 0 订阅

订阅专栏


 select TO_DATE('01/01/1970', 'MM/DD/YYYY') + r.starttime / 86400000 +
                TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) / 24
                 into startdate
 select TO_DATE('01/01/1970', 'MM/DD/YYYY')  from dual;

select '86400000' / 86400000 + TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) / 24 from dual;

select TO_NUMBER('01/01/1970', 'MM/DD/YYYY') / 86400000 + TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) / 24 from dual;

select TZ_OFFSET(sessiontimezone) from dual;

select SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3) from dual;

select TO_NUMBER(SUBSTR(TZ_OFFSET(sessiontimezone), 1, 3)) from dual;

select 8 /24 from dual;