Re: Help needed on date conversion

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 14 Oct 2005 18:26:33 -0700
Message-ID: <Y9Cdnbi3tK3vx83eRVn-pQ@comcast.com>

<nekkalapudi.siva_at_gmail.com> wrote in message news:1129275268.340949.182960_at_o13g2000cwo.googlegroups.com... I have my language set as Chinese.
I have the following date "14-10?-2005". I need to convert the date in English.
Is there a simple way of doing it

I believe you have it set to Japanese. The date you have there is October 14th, 2005.
Set it to English. Look at nls date format. The date inside Oracle is stored in a binary format not language specific. You have it represented as a string.
Jim Received on Fri Oct 14 2005 - 20:26:33 CDT