title: Sql server get only the date from a DateTime and filter on it
body: <p>I have a database in Sql Server with TimeSpan column the date in the TimeSpan column format is : 14/03/2022 18:50:21</p>
  <p>I was looking for a way how to sort the data by day and month. The only problem is i have also time included into the database which seems to be an issue to filter on. Somehow i'm not able to only filter by days/months. Its not giving me an error which i understand i just need a wat to provide a time...</p>
  <p>I've tried :</p>
  <p><strong>With wild cards.</strong></p>
  <pre><code>Select * from MBR where TAG='FT_AV_03' AND TimeStamp LIKE '03/14/2022 __:__:__' 
  
  Select * from MBR where TAG='FT_AV_03' AND TimeStamp LIKE '03/15/2022 %'
  </code></pre>
  <p><strong>With Contains</strong></p>
  <pre><code>select * from MBR where TimeStamp like '03/15/2022%'
  </code></pre>