title: mysql date_format needs to return as string
body: <p>I have a small sql query that get the date part of a date time column</p>
  
  <pre><code>Select DATE_FORMAT(`tbldata`.`fldDate`, '%d/%m/%Y') AS formattedDate from tbldata
  </code></pre>
  
  <p>How can I convert this to a string?</p>
  
  <p>I am running the sql query in a vbscript file and adding the returned data into an excel spreadsheet.</p>
  
  <p>However, the script fails because the returned data is a date type.</p>
  
  <p>Is there a way to ensure that the date returned from mysql is a string and not a date?</p>
  
  <p>Thanks</p>