Hi everyone,
I'm trying to store row created date with time into table using "localtimestamp" but it is storing the wrong time as below
26-JUN-21 08.20.25.728602 AM but the time is 26-JUN-21 13:51PM
what could be the reason?
Thanks in Advance....
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
pavlos
Hi!
Did you check your time zone settings?
Go to app > Edit application attributes > Globalization and set Automatic Time Zone to on.
From Oracle Apex help:
"Controls the setting of the database session time zone. When set to On, the client time zone is derived from the client's Web browser and set for the duration of the Application Express session. Subsequent page views will have the database session time zone set properly per page view. Once set, this setting can be overridden using
APEX_UTIL.SET_SESSION_TIME_ZONE
, or reset usingAPEX_UTIL.RESET_SESSION_TIME_ZONE
."VARSHA
Thank you for the reply pavlos
Automatic time zone was off, i set it on. Now it is showing correct time.