How to retrieve the date records based on today's date in C# and MySQL

Question

I want to select the records where the dateTimefield is equal to today's date. The DBMS is MySQL.

Answer 1

SELECT * FROM tableName WHERE DATE_FORMAT(dateField,'%m-%d-%Y')=DATE_FORMAT(NOW(),'%m-%d-%Y');

Answer 2

SELECT * FROM my_table WHERE DATE(dateTimefield) = CURRENT_DATE