title: Howto convert datetime to date with an ODBC function?
body: <p>Question:</p>
  
  <p>I need to get the DATE ONLY (= date WITHOUT time) <strong>with an ODBC escape sequence</strong>.</p>
  
  <p>However</p>
  
  <pre><code>SELECT 
       {fn CONVERT(SomeTable.Col_With_DateTime_Value, SQL_DATE)}
  FROM SomeTable
  </code></pre>
  
  <p>does return the column as datetime value (date WITH time).</p>
  
  <p>Is there any <strong>ODBC function</strong> I can use to get the <strong>date</strong> value <strong>only</strong> ?</p>
  
  <p>Note:<br />
  This is not a duplicate question. <br />
  I know one can use the <strong>non</strong>-ODBC convert function, like</p>
  
  <pre><code>CONVERT(char(8),  getdate(), 112) AS v112_ISO  
  CONVERT(char(10), getdate(), 104) AS v104_XML  
  </code></pre>
  
  <p>but I really need an <strong>ODBC</strong> function for compatibility reasons.</p>