SQL SERVER - Date conversion failed
<p>I have a table in which <code>AccessDate</code> column is of type <code>datetime</code>.
And I am trying to do something like this:</p>

<pre><code>SELECT 'AccessDate' UNION ALL SELECT AccessDate FROM table_name
</code></pre>

<p>I am trying to insert the header of the table "AccessDate" into the result of the query.
And this error shows up after executing:</p>

<blockquote>
  <p>Conversion failed when converting date and/or time from character string.</p>
</blockquote>

<p>Can someone help me with this? Thank you.</p>