Select Convert(Varchar(20),Cast(Convert(Varchar(10),GetDate(),120) As DateTime),120)Select Convert(Varchar(20),DateAdd(d,1,DateAdd(ss,-1,Convert(Varchar(10),GetDate(),120))),120)
declare @ datetime set @ = getdate() select dateadd(day,datediff(day,0,@),0) ,dateadd(second,-1,dateadd(day,datediff(day,0,@)+1,0))
playyuer(退休干部 卧鼠藏虫),不行的。你得到的时间全部带了毫秒的。
Select Convert(Varchar(20),Cast(Convert(Varchar(10),GetDate(),120) As DateTime),120)Select Convert(Varchar(20),DateAdd(d,1,DateAdd(ss,-1,Convert(Varchar(10),GetDate(),120))),120)
set @ = getdate()
select dateadd(day,datediff(day,0,@),0)
,dateadd(second,-1,dateadd(day,datediff(day,0,@)+1,0))
select convert(datetime,convert(char(8),getdate(),112))
select dateadd(ss,-1,convert(datetime,convert(char(8),getdate()+1,112))) 不过也是带了毫秒的
应该由客户端程序去控制显示格式!