DBTIMEZONE SQL Query | IFS Community
Solved

DBTIMEZONE SQL Query

  • 24 November 2021
  • 1 reply
  • 54 views

Userlevel 2
Badge +7
  • Do Gooder (Customer)
  • 13 replies

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?

icon

Best answer by Manoj Ruwanhewa 24 November 2021, 13:44

View original

1 reply

Userlevel 7
Badge +14

Hi @awe ,

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

 

Reply