Re: VARCHAR2 to DATE Conversion Error

From: misha-kostromich <bronshvayg_at_yahoo.com>
Date: 15 Aug 2002 17:04:01 -0700
Message-ID: <c6c2b410.0208151604.34fb5d82@posting.google.com>

Keep thinking....

select

decode(sign(instr(a_date_column, 'th')), 1,
    to_char(to_date(a_date_column, 'Month DD"th"YYYY'),'DD-MON-YYYY')
    ,decode(sign(instr(a_date_column, 'rd')), 1,
       to_char(to_date(a_date_column, 'Month DD"rd"YYYY'),'DD-MON-YYYY')
       ,decode(sign(instr(a_date_column, 'nd')), 1,
            to_char(to_date(a_date_column, 'Month DD"nd"YYYY'),'DD-MON-YYYY')
            ,to_char(to_date(a_date_column, 'Month DD"st"YYYY'),'DD-MON-YYYY')
       )

    )
)
from a_table Received on Thu Aug 15 2002 - 19:04:01 CDT