Home Forums SQL Server 2005 SQL Server 2005 General Discussion how to get last two weeks data. RE: how to get last two weeks data.

  • September 25, 2014 at 9:49 am

    #1748241

    try this: select DATEADD(dd,-14,CONVERT(datetime,CONVERT(nvarchar(11),GETDATE())))