declare @time datetime set @time='2005-2-1 19:34:35' select left(convert(varchar(20),@time+1,120),11)+'00:00:00'
declare @Date datetime set @Date='2005-2-1 19:34:35' select case when Convert(char(8),@Date,108)<>'00:00:00' then convert(char(10),dateadd(day,1,@Date),120) else @Date end
use tempdb go declare @Date datetime set @Date='2005-2-1 19:34:35' select case when Convert(char(8),@Date,108)<>'00:00:00' then convert(char(10),dateadd(day,1,@Date),120) else @Date end
set @time='2005-2-1 19:34:35'
select left(convert(varchar(20),@time+1,120),11)+'00:00:00'
declare @Date datetime
set @Date='2005-2-1 19:34:35'
select case when Convert(char(8),@Date,108)<>'00:00:00'
then convert(char(10),dateadd(day,1,@Date),120) else @Date end
go
declare @Date datetime
set @Date='2005-2-1 19:34:35'
select case when Convert(char(8),@Date,108)<>'00:00:00'
then convert(char(10),dateadd(day,1,@Date),120) else @Date end