title: Converting Date Format in Advantage SQL
body: <p>I have a simple problem in Advantage Database SQL. </p>
  
  <p>I have dates in the format M/D/YYYY and want to convert them MM/DD/YYYY. Normally in SQL Server I would just use a convert(varchar(20), field, 101) but this does not work in Advantage. </p>
  
  <p>What is the format for doing so?</p>