title: Excel isn't reading sql exported csv properly
body: <p>I have a batch file that calls sqlcmd to run a command and then export the data as a csv. When viewed in a cell the trasancted date for example shows <code>35:30.0</code> but if you click on it the formula bar shows <code>1/1/1900 2:45:00 PM</code>. I need the full timestamp to show in the cell. Any ideas?</p>
  
  <p>The batch file is the following</p>
  
  <pre><code>sqlcmd -S server -U username -P password -d database -i "D:\path\sqlScript.sql"  -s "," &gt; D:\path\report.csv -I -W -k 1
  </code></pre>
  
  <p>The script is the following. Now I currently have them cast as varchars, but that's simply because i've tried to change it a bit. Varchar doesn't work either.</p>
  
  <pre><code>SET NOCOUNT ON;
  
  select top(10)BO.Status,
  cast(tradeDate AS varchar) AS Trade_Date,
  CAST(closingTime AS varchar) AS Closing_Time,
  CAST(openingTime AS varchar) AS openingTime
  </code></pre>
  
  <p>FROM GIANT COMPLICATED JOINS OF ALL SORTS OF TABLES</p>