Home Forums SQL Server 2008 SQL Server Newbies Extract only the last three days RE: Extract only the last three days
Andrew G
SSChampion
Points: 12809
More actions
March 5, 2013 at 3:41 am
#1593368
Oh just noticed I gave you the wrong syntax for that first reply (DAY instead of d)
[SQL] SELECT * FROM tbl WHERE CONVERT(datetime, [myDateString], 103) > DATEADD(d, -3, getdate())