Date Calculations

• Stephen crocker

  SSCrazy

  Points: 2512

  More actions

  August 17, 2007 at 1:27 pm

  #175997

  I would like to calculate dates to return number of years and number of day's to look like this 

  i.e 30 Years and 21 Days = Don't ask why it's how the work it.

   

  I would like to check for an joindate and calculate the number of date's to today

  It's just stumping me

  let's say the table looks like this

  cst_id----joindate-----expire date----terminate_Date

   

  I don't want to use a function case I only need it one time.

  Thanks in advance.

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  August 17, 2007 at 3:04 pm

  #727759

  declare

  @date smalldatetime,

  @days int

  set @date = '07/16/1998'

  select

  @days = datediff(dd, @date, getdate())

  print

  cast(cast(@days/365.25 as int) as varchar(2)) + ' years and ' + cast(cast(round(@days % 365.25,0) as int) as varchar(3)) + ' days.'

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  August 18, 2007 at 2:55 am

  #727797

  See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=391727#bm391755

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78730

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62729

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"