How to convert date format using SQL

[DavidCantor]

I need to convert the date format October 10th, 2013 to 10/01/2013 in a field using sql in access 2010,
I know it has to be an update query but dont know how to start writing the query.

 

[pbaldy]

If it's a date field, it's just a formatting issue, it's not stored that way (it's stored as a Double). I'd just format it on forms and reports.