title: SQL query to show data by today(current) date?
body: <p>I am trying to get the record from database with current date only here is the query I have tried bu getting no records from table:</p>
  
  <pre><code>SELECT *
  FROM Transactions
  WHERE transaction_date = GETDATE(); 
  </code></pre>