title: Insert just the date to MS access database using FireDac
body: <p>I have a table called <code>Students</code> , in this table there is a <code>date</code> column called <code>BirthDay</code> with <code>Date, abbreviated</code> format (eg : 26/06/2017), the problem is in delphi the <code>Field</code> type is <code>SQLTimeStamp</code>, and I want to save just the <code>Date</code> not a <code>DateTime</code>.</p>
  
  <pre><code>DM.TStudentsBirthDay.Value := DateTimeToSQLTimeStamp(DateTimePicker1.Date);
  </code></pre>
  
  <p>That will post a <code>DateTime</code>.</p>
  
  <p>How can I fix this? How can I insert just the date?</p>
  
  <p>Update :</p>
  
  <p>I try to do it with <code>TFDQuery</code> component and it works perfectly , also with <code>TAODTable</code> component.</p>