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:

```
SELECT *
FROM Transactions
WHERE transaction_date = GETDATE(); 

```