如何按日期从mysql数据库中选择数据[关闭]

Question

I have an DB Table with a column appointment_date [type: date], I want select all the data matching with today's date.

Answer 1

MS SQL Server

Use CURRENT_TIMESTAMP function

select * from dates where appointment_date = CAST(CURRENT_TIMESTAMP AS DATE);

MYsQL

select * from dates where appointment_date = cast(now() as date);