Re: Convert date format

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