Date manipulation

• vinoth_983

  SSC Enthusiast

  Points: 173

  More actions

  July 11, 2008 at 12:53 am

  #381593

  May you help to me, I want input date adding to 6 months through Stored procedure?

  example

  11/07/2008

  +6months

  11/01/2009

  how to calculate ?

  how to check leap year check and month day check 30 or 31 check

  Please sent query to me

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  July 11, 2008 at 1:14 am

  #841278

  Hey Vinoth,

  Try this:-

  DECLARE @Date datetime

  SET @Date = '07/11/2008'

  SET @Date = DateAdd(mm,6,@Date)

  SELECT @Date Date

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 11, 2008 at 8:04 am

  #841508

  Look up "DateAdd" in Books Online.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon