SQL & PL/SQL

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!

Date TO_CHAR Formatting Issues

frankstuartbrowneSep 22 2010 — edited Sep 24 2010

Hi Team,

I'm a newbie and this is my first post here so please bear with me. I'm having an issue with converting a date column to string using the TO_CHAR function. See below for a few examples:

ORACLE_DATE; DATE_CHAR; DUMP(ORACLE_DATE);
31-DEC-02; 0000-00-00 00:00:00; Typ=12 Len=7: 100,100,1,0,1,1,1;
16-JAN-97; 1197-01-16 00:00:00; Typ=12 Len=7: 111,197,1,16,1,1,1;
01-DEC-06; 0006-12-01 00:00:00; Typ=12 Len=7: 100,106,12,1,1,1,1;
01-JUL-66; 1966-07-01 22:52:44; Typ=12 Len=7: 119,166,7,1,23,53,45;

Is there any way I can determine what the actual date recorded is from the data provided?

Thanks

Edited by: user11181700 on Sep 22, 2010 12:59 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2010

Added on Sep 22 2010

#date

14 comments

4,815 views