Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |