Hi!
Running this query:
select SYSDATE, current_date, SYSTIMESTAMP, DBTIMEZONE FROM dual
We wondering what is DBTIMEZONE, and how is it used in IFS?
Can anyone explain more about this?
Best answer by Manoj Ruwanhewa
View originalHi!
Running this query:
select SYSDATE, current_date, SYSTIMESTAMP, DBTIMEZONE FROM dual
We wondering what is DBTIMEZONE, and how is it used in IFS?
Can anyone explain more about this?
Best answer by Manoj Ruwanhewa
View originalHi
SYSDATE returns the current date and time set for the operating system on which the database server resides.
CURRENT_DATE returns the current date in the session time zone.
DBTIMEZONE is the internal time zone of TIMESTAMP WITH LOCAL TIME values
current time at DBTIMEZONE can be fetched as below
select SYSTIMESTAMP AT TIME ZONE DBTIMEZONE from dual;
Local time zone can be changed as per the below article
https://www.databasejournal.com/features/oracle/article.php/3072991/Oracle-Time-Zone.htm
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.