title: How to get DATE from DATETIME Column in SQL?
body: <p>I have 3 columns in Table TransactionMaster in sql server</p>
  
  <p>1) transaction_amount</p>
  
  <p>2) Card_No</p>
  
  <p>3) transaction_date-- <code>datetime</code> datatype</p>
  
  <p>So, I want to fetch SUM of  <code>transaction_amount where Card_No=' 123'</code> and <code>transaction_date= todays date</code>.&lt;----- excluding time IN SQL</p>