title: Database agnostic SQL for returning list for Date of birth stored as a Timestamp
body: <p>If I need to search on Date of birth which is stored without the hours and minutes but the date I have to search with includes hours and minutes what is the best way to return all rows where date is matched on only day, month and year</p>
  
  <p>i.e. <br/> 
  Stored as      01-JAN-50 10.22.06.000000000<br/>
  date selected  01-JAN-50 10.22.06.010101120</p>
  
  <p>If I use the date with the hours and minutes the SQL will only return rows with the exact timestamp and not those for just the day, month and year.</p>
  
  <p>The SQL needs to work on Oracle, SQLServer, MySQL and DB2.</p>