How to get the first day of any month

• lefrancisco1

  Say Hey Kid

  Points: 704

  More actions

  August 25, 2009 at 10:41 pm

  #209917

  Hi Folks,

  How to get the first ay of any month, Normally we will concatenate '01' TO DATE FUNTION and set 01 as the default first day of the month.bUT FOR EVERY MONTH I SHOULD GET FIRST DAY

  EXAMPLE; firstday of the month is 01 with their datename(week day)

• arun.sas

  SSChampion

  Points: 11831

  More actions

  August 25, 2009 at 11:17 pm

  #1044676

  HI,

  TRY THIS

  select getdate() + (1 - DAY(getdate()))

  select DATENAME(weekday,(getdate() + 1 - DAY(getdate())))

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 26, 2009 at 9:41 am

  #1044970

  Here's a link to a blog post by Lynn Pettis that I refer to whenever I need a date routine.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  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

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  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..