Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Convert date format

Re: Convert date format

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 20 Sep 2006 10:50:09 +0200
Message-ID: <4ncdm1F9m512U2@individual.net>


On 20.09.2006 10:16, RJ wrote:
> Hi all,
>
> I have a VARCHAR field that contains dates in the format dd/mmm/yy
> (E.G. 26/AUG/06)
> how do i change this to dd/mm/yyyy?

Convert it to DATE and back. You should however change the column type to a more appropriate one (DATE or one of the TIMESTAMP types depending on what you want to do with it).

        robert Received on Wed Sep 20 2006 - 03:50:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US