Question

DBTIMEZONE SQL Query

  • 24 November 2021
  • 1 reply
  • 25 views

Userlevel 1
Badge +4
  • Do Gooder
  • 6 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?


1 reply

Userlevel 6
Badge +13

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