Home Forums SQL Server 2005 SQL Server Newbies How to get the first day of any month RE: How to get the first day of any month

  • January 9, 2017 at 1:56 am

    #1921315

    select getdate() + ((1 - DAY(getdate()))) If today is 01 then it wont work to pick first day of month..