My Oracle Support Banner

TO_CHAR(SYSDATE,'D') Returns Different Values on Client and Server (Doc ID 1062608.6)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Forms - Version 6.0.8 to 11.1.2.0.0 [Release 6.0.8 to 11g]
Microsoft Windows (32-bit)

Symptoms

Using the following code: to_char(sysdate,'d').
The result of the above from client side tools such as Sql Plus and Forms
was 2. The result of the above from the server side Sql Plus was 1.
The actual sysdate returned is the same on both client and server.

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!

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