My Oracle Support Banner

NOW Function and current_timestamp Function Return Different Time on the Machine Whose Timezone is JST (Doc ID 2995071.1)

Last updated on JANUARY 04, 2024

Applies to:

Oracle Analytics Server - Version 2023 and later
Information in this document applies to any platform.

Symptoms

On the environment whose the operating system time zone is JST, when "Default Time Zone for Date Calculations" on System Settings is set to (GMT+09:00),
NOW function and current_timestamp function shows JST+9hours time , not JST time.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.