title: How to flip month and day in a datetime?
body: <p>How can I flip "2012-<strong>12-01</strong> 12:33:00.0" to become "2012-<strong>01-12</strong> 12:33:00.0"? I had tried "select convert(varchar(50), convert(datetime, log_date, 103), 121)" and used both 101 and 103 and still not able to flip it.</p>
  
  <p>The database is MS SQL</p>