select getdate() -- 2017-01-23 13:37:41.053
select datename(day,getdate()) -- 23
select convert(varchar(10), getdate(), 23) -- 2017-01-23
select convert(varchar(10),getdate(),120)+'00:00:00',convert(varchar(11),getdate(),120)+'23:59:59'
select dateadd(day,1,getdate()) -- 2017-01-24 13:38:08.167
select convert(datetime,convert(varchar(10),getdate(),011)) -- 011/23/112/120 2017-01-23 00:00:00.000
select dateadd(day,1,convert(datetime,convert(varchar(10),getdate(),112))) -- 2017-01-24 00:00:00.000
select dateadd(SS,-1,dateadd(DD,1,convert(datetime,convert(varchar(10),getdate(),120)))) -- 2017-01-23 23:59:59.000
sql获取时间段
最新推荐文章于 2024-07-30 17:35:10 发布