Solved

DBTIMEZONE SQL Query

  • 24 November 2021
  • 1 reply
  • 115 views

Userlevel 2
Badge +7
  • Do Gooder (Customer)
  • 21 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

This topic has been closed for comments

1 reply

Badge +15

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