我有这个表的结构:
CREATE TABLE Department
(
[IdDepartment] int,
[Name] varchar(23),
[IdUser] int,
[CreateDate] datetime
);
INSERT INTO Department ([IdDepartment], [Name], [IdUser], [CreateDate])
VALUES
(1, 'Sales', 3, '2016-01-15 17:00:00.000'),
(2, 'Finance', null, '2016-01-13 18:00:00.000' ),
(3, 'Accounting' , 5, '2016-03-21 22:00:00.000'),
(4, 'IT' ,3, '2016-03-21 17:00:00.000'),
(5, 'Secretary',null, '2016-03-21 17:00:00.000'),
(6, 'Sport',3, '2016-02-20 16:00:00.000');
我要运行此查询:
select Name
from Department
where CreateDate = '2016-03-21'
结果将返回0行。
我认为这是因为表结构中的日期是日期时间,但我尝试这样做但对我都不起作用:
select Name
from Department
where CreateDate like '%2016-03-21%'
结果应该是这样的:
Name
-----
Accounting
IT
Secretary
我怎么能得到这个结果?
希望我解释清楚,谢谢
使用CAST
方法只比较日期而不是时间
SELECT * FROM Department
WHERE CAST(CreateDate AS DATE) ='2016-03-21'
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句