select case when convert(time,getdate())<'08:00:00' then convert(varchar(10),dateadd(day,-1,getdate()),120)+' 20:00:00' WHEN convert(time,getdate())<'08:00:00' THEN convert(varchar(10),getdate(),120)+' 20:00:00' else convert(varchar(10),getdate(),120)+' 08:00:00' end