Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What do i do so that sysdate and current_timestamp display same values

3752786Jul 23 2019 — edited Jul 23 2019

Oracle 12c

sql developer

Hi,

I am getting different values for sysdate and current_timestamp.

I am slightly confused , as the database resides in India, it is still displaying another timezone

CURRENT_TIMESTAMP

---------------------------------------------

23-JUL-19 11.37.00.461000000 AM ASIA/CALCUTTA

SYSDATE SYSTIMESTAMP

--------- --------------------------------------

22-JUL-19 22-JUL-19 11.07.18.024000000 PM -07:00

I want to change it to India.

what i want is that sysdate should store date as per India.

How i achieve it?

Added on Jul 23 2019

#general-database-discussions

8 comments

1,312 views