Viewing post 1 (of 1 total)
U can go for this solution:
declare @temp varchar(20)
select @temp = GETDATE()
select DATEADD(day, -1, @temp)
December 13, 2004 at 9:26 pm
#533681