<div>
Thanks for taking the time to show the example.
</div>


Thanks for taking the time to show the example.

<div>
<div class="content wysiwyg-content">
Our database contains a table called accountinfo with a column called fields_4 the current format is this:<br />
3/15/2012 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
3/16/2012 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
3/17/2012 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
3/18/2012 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
This is what we would like to have.<br />
2012-03-15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
2012-03-16 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
2012-03-17 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
2012-03-18 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
We need to keep the format in varchar for scripting reasons not date format.<br />
<br />
I was thinking something like this <br />
Set Date_Field = Convert(datetime, VarChar_Field, 101) .<br />
Thanks
</div>
</div>


Our database contains a table called accountinfo with a column called fields_4 the current format is this:
3/15/2012	
3/16/2012	
3/17/2012	
3/18/2012	

This is what we would like to have.
2012-03-15	
2012-03-16	
2012-03-17	
2012-03-18	
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) .
Thanks

Convert Mysql varchar (10) dd/mm/yyyy to varchar (10)  YYYY-MM-DD format

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.