-
Convert char date m/d/yyyy to mm/dd/yyyy?
I have a char(30) variable in the database that in some instances it has 2/2/2009 and some have 02/02/2009. I am wanting to write an sql update query that goes through and updates all instance of m/d/yyyy to mm/dd/yyyy how do I do this being that it is of type char?
This was a result of data entry problem, different people entered data in different ways, and now that we have to go back through and change it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|