The last expression adds one hour, which can be done after the conversion between the datatypes is complete:
select TO_CHAR(SYSTIMESTAMP,'yyyy/mm/dd hh24:mi:ss.ff tzh:tzm'), TO_TIMESTAMP_TZ(to_char(SYSTIMESTAMP,'yyyy/mm/dd hh24:mi:ss.ff tzh:tzm'),'yyyy/mm/dd hh24:mi:ss.ff tzh:tzm'), TO_TIMESTAMP_TZ(to_char(SYSTIMESTAMP,'yyyy/mm/dd hh24:mi:ss.ff tzh:tzm'),'yyyy/mm/dd hh24:mi:ss.ff tzh:tzm')+1/24 from dual;
systimestamp | TIMESTAMP_TZ | TIMESTAMP_TZ + 1hr |
---|---|---|
2017/02/01 10:36:28.158921 +01:00 | 01/02/2017 10:36:28,158921000 +01:00 | 01.02.2017 11:36:28 |
No comments:
Post a Comment