Database Administration (MOSC)

MOSC Banner

Date Format - Year is displayed incorrectly

edited Apr 6, 2010 9:34AM in Database Administration (MOSC) 4 commentsAnswered
Oracle is currently working on an SR on this topic, while we are diagnosing the problem we are opening up this question to our user community so they can add perspective to the solution based on their real world experience

We are trying to do select and the output is
select TO_CHAR(BIRTH_DT, 'dd/mm/yyyy')  from TBL_PERSON where IP_C2O_NO = 'C0929476/CT/A';

TO_CHAR(BI
----------
01/01/0019

Below are the NLS settings

SQL> select * from nls_database_parameters order by 1;

PARAMETER                      VALUE
------------------------------ --------------------------------------------------
NLS_CALENDAR                   GREGORIAN
NLS_CHARACTERSET               UTF8
NLS_COMP                       BINARY
NLS_CURRENCY                   $

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center