I have a cursor with a date field in it. I need to save this cursor as a CSV file so..........

COPY TO (myFile) CSV

but........

the date field is saved as MM/DD/YYYY and the user needs it in DD-MMM-YY format. Is there a reasonably easy way to make this format change???? (I've tried various SET DATE settings but didn't seem to get what I need)

I haven't yet tried it (task for tommorrow or Thursday) but the next attempt is going to be

save as XLS
open an instance of Excel
load the file (where it displays as desired)
and then SaveAs CSV from Excel

Any thoughts on if this should work and/or suggestions for a better approach are appreciated.

Thanks to all.........Rich