title: ruby on rails date format problem
body: <p>Hi<br>
  In my application the user can selects a date in a  "dd/mm/yyyy" format from a calendar and save it to a date field in the database (mySql).<br>
  Everything is going ok on my local server (in Israel) but on my host server ( in the US) it fails.<br>
  I did some checking in the console and found that <br>
  <strong>in my local computer(Israel)</strong> when I do the following:<br></p>
  
  <blockquote>
    <p>d=Date.new<br>
    d.reported_date="23/01/2011",br>
    d.save<br>
    I get<br>
    =>true.<br></p>
  </blockquote>
  
  <p><strong>In my host server(US)</strong> when I do the following:<br></p>
  
  <blockquote>
    <p>d=Date.new<br>
    d.reported_date="23/01/2011"<br>
    d.save<br>
    I get<br>
    =>false<br></p>
  </blockquote>
  
  <p>When I did this check with another date for example "04/01/2011"<br>
  the local and the host could save the record.<br></p>
  
  <p>So I concluded  that it seems like  the host(in US)  can receive date only  in "mm/dd/yyyy" format and convert it to mySql date format<br>
  and the local computer(in Israel) can received date only in "dd/mm/yyyy" format and convert it to mySql   date format.<br>
  (Both in the server and in my local machine the format in the mySql server is  yyyy-mm-dd)</p>
  
  <p>I need to find a solution which can  adjust  mySql in my local machine to behave like in the host server.</p>
  
  <p>I will be glad to some advise</p>
  
  <p>Thanks</p>