Home Forums SQL Server 2005 Development Date Issue RE: Date Issue
Lynn Pettis
SSC Guru
Points: 442467
More actions
November 19, 2012 at 12:37 am
#1560182
Simple:
declare @ThisDate datetime;
set @ThisDate = getdate();
select @ThisDate, dateadd(qq, datediff(qq, 0, @ThisDate), -1);
set @ThisDate = '20120507';