34,593
社区成员
发帖
与我相关
我的任务
分享
select * from tb where convert(varchar(10),日期字段,120)='2008-07-04'
select *
from tb
where convert(varchar(10),col)='2008-07-04'
insert tb(a)
select a from tb where convert(nvarchar(10),日期字段,120) = '2008-09-25'
select * from 表
where convert(nvarchar(10),DateCol,120) = '2008-09-25'
select * from 表 where convert(varchar(10),日期,120)='2008-07-04'
declare @myday datetime
set @myday ='2008-07-04 13:59:00.000'
select * from 表
where convert(nvarchar,myday,120) = convert(nvarchar,@myday,120)
declare @myday datetime
select * from 表
where convert(nvarchar,myday,120) = convert(nvarchar,@myday,120)
select * from 表 where datediff(day,日期,'2008-07-04')=0