Reformat date to MM/DD/YYYY Format

[JackBurton07]

At present I have a field "DOB" in DD/MM/YYYY format - I want to use SQL to reformat this to MM/DD/YYYY Format.

Any ideas as Im stuck!

Thanks

JB

 

[traingamer]

If it's a date field, simply change the display format.

If not (i.e. it's a character field), create a temporary field, and copy the data there, changing the format. When you're satisfied with the results, copy from the temporary field back to the original column.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill