Home Forums SQL Server 2008 T-SQL (SS2K8) get the first date and weekday of every month in a year RE: get the first date and weekday of every month in a year

  • March 10, 2014 at 11:57 am

    #1695690

    --First Day of this Month

    select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)

    vamsikrishnacheruku (3/10/2014)

    hai i want to get the first date and weekday of every month in a year .

    1/jan/2014, monday

    1/feb/2014,thrusday

    , ,

    ,,

    ,,

    ,,,

    ,,,

    ,,

    1/nov/2014, thrusday

    1/dec/2014, friday

    like this output should be