Posted on: 7/23/2012 6:04:08 AM | Views : 325

Hi,
I ham running the following select statement into SQL.
Select I_NOTE_DESIGS.END_DATE AS ENDDATE
However in my results the date hows as 01-APR-29.  I was wondering if there is a way to convert this over to another date string ie: I would like the date in this column to show 2029-04-01.  I am not bothered if the time comes out at the end, as I have a program which can delete that.
Regards,
Jon Ditchfield
...

Go to the complete details ...