Home Forums SQL Server 2008 T-SQL (SS2K8) TSQL DATEADD Help RE: TSQL DATEADD Help

  • May 17, 2013 at 1:12 pm

    #1616327

    GBeezy (5/17/2013)

    I give up too easily and over complicate things, I believe I have what I need below:

    SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 18, 0)

    Thanks

    Or this:

    select datadd(month, datediff(month,0,getdate()), 0)

    You may want to check out this:

    http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/