SQL 服务器 - 消息 195，级别 15，状态 10，第 6 行 "日期时间"不是可识别的内置函数名称

Question

运行此查询时出现错误

declare @currentDate datetime
set @currentDate = getdate()
select count(Id) 
    from dbo.tblLstOfClientHolidays 
    where Datetime(@currentDate) = CONVERT(VARCHAR(10),getdate(ClientHoldiday),10)

Answer 1

Select  
    count(Id) 
From    
    dbo.tblLstOfClientHolidays 
Where   
    CONVERT(VARCHAR(10),ClientHoldiday,10) = CONVERT(VARCHAR(10),@currentDate,10)

Answer 2

由于您使用的是SQL Server 2008，您甚至可以将CONVERT转换为DATE，而不是转换为VARCHAR然后进行比较。

DECLARE @currentDate DATE;
SET @currentDate = GETDATE();
SELECT count(Id) 
FROM dbo.tblLstOfClientHolidays 
WHERE CONVERT(DATE,@currentDate) = CONVERT(DATE,ClientHoldiday);