SQL query to show data by today(current) date?

Question

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(); 

Answer 1

It's the current date, so the records with future dates don't exist. You just need to get all transactions greater than 00:00:00 of today.

SELECT * FROM `Transactions` WHERE transaction_date >= CURRENT_DATE+" 00:00:00";

Answer 2

Just compare the date part

   Select *from Transactions
        WHERE 
    CONVERT(char(10), transaction_date  ,126)=CONVERT(char(10), getdate(),126);