title: Sql convert date format
body: <p>I want to convert dateformat from mm/dd/yyyy to yyyy/mm/dd. I want the output in datetime format.
  I tried this </p>
  
  <blockquote>
    <p>convert(datetime,convert(varchar,getdate(),111),123)</p>
  </blockquote>
  
  <p>but doesn't work. The error is "explicit conversion to datetime not available"
  What is the best way to solve this problem? I'm using Sybase.</p>