Getdate and Datepart

• Rick Musa

  Old Hand

  Points: 374

  More actions

  February 21, 2006 at 2:08 pm

  #103093

  Hello All,

  I'm looking for options on using getdate. What I'm trying to get from getdate () is

  01-2006

  On the fly my first thought was:

  set @v_reportdate = getdate() -21

  set @v_GetMoYear = CAST (DATEPART(MM, @v_reportdate)AS VARCHAR) + '-' + CAST (DATEPART(YY, @v_reportdate)AS VARCHAR)

  This works and returns 1-2006. Any other options are welcome.

  Thanks,

  Rick

• Krishnan Kaniappan

  Ten Centuries

  Points: 1051

  More actions

  February 21, 2006 at 2:26 pm

  #622457

  declare @year char(4),@month char(2)

  set @year=convert(char(4),getdate(),120)

  set @month=right(convert(char(7),getdate(),120),2)

  select @month + '-' + @year

  

   

  -Krishnan

• Rick Musa

  Old Hand

  Points: 374

  More actions

  February 21, 2006 at 3:02 pm

  #622468

  Thanks Krishnan!

  That is much cleaner.

  Rick-

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  February 22, 2006 at 7:07 am

  #622604

  or

  SELECT STUFF(CONVERT(varchar,GETDATE(),110),3,3,'')

  Far away is close at hand in the images of elsewhere.
  Anon.