关闭。这个问题需要更加突出重点。它目前不接受答案。**想改进这个问题吗？**通过编辑这篇文章更新这个问题，使它只关注一个问题。
两年前关门了。改进这个问题我有一个db表，它的列“约会日期”[类型：日期]，我想选择与今天日期匹配的所有数据。
gopyfrb31#
ms sql服务器使用当前时间戳函数 select * from dates where appointment_date = CAST(CURRENT_TIMESTAMP AS DATE); mysql数据库 select * from dates where appointment_date = cast(now() as date);
select * from dates where appointment_date = CAST(CURRENT_TIMESTAMP AS DATE);
select * from dates where appointment_date = cast(now() as date);
1条答案
按热度按时间gopyfrb31#
ms sql服务器
使用当前时间戳函数
select * from dates where appointment_date = CAST(CURRENT_TIMESTAMP AS DATE);mysql数据库select * from dates where appointment_date = cast(now() as date);