Convert Mysql varchar (10) dd/mm/yyyy to varchar (10) YYYY-MM-DD format
Posted on 2012-04-10
Our database contains a table called accountinfo with a column called fields_4 the current format is this:
This is what we would like to have.
We need to keep the format in varchar for scripting reasons not date format.
I was thinking something like this
Set Date_Field = Convert(datetime, VarChar_Field, 101) .