Substr, to_char gives a difference of 1 hour from actual time

Published: 14/06/2019
Substr, to_char gives a difference of 1 hour from actual time
Source: ASKTOM.ORACLE.COM

Hello, 1) When we execute below query : <code>with rws as ( (SELECT (FROM_TZ(CAST(sysdate AS TIMESTAMP), 'Europe/Paris') AT TIME ZONE (select nvl(timezone,'Europe/Paris') date1 from dim.nloqt_top_sit_d where sit = 'KE' )) sysd FROM DUAL)...

Read more
Related news
Comment
FACEBOOK