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

  • August 26, 2009 at 10:19 am

    #1044999

    select FirstDayOfMonth = dateadd(mm,datediff(mm,0,getdate()),0)

    Results:

    FirstDayOfMonth

    -----------------------

    2009-08-01 00:00:00.000