Home Forums SQL Server 2008 SQL Server 2008 - General Need to write query for Date logic RE: Need to write query for Date logic

  • May 25, 2015 at 5:29 am

    #1800362

    SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) , 0);

    SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) + 1 , 0);

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day