JackBurton07
IS-IT--Management
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
Any ideas as Im stuck!
Thanks
JB
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reformat date to MM/DD/YYYY Format
- Thread starter JackBurton07
- Start date
- Status
traingamer
Programmer
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
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
- Status
Similar threads
- Question
