Using DATEDIFF

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  October 14, 2004 at 7:22 am

  #89730

  I've used the DATEDIFF function several times in calculating the number of days between dates.  I'm now wanting to calculate the number of months.  Not a big deal, but what if I want to see a decimal after the value?

  E.G. DATEDIFF(mm,'5/29/04','4/1/05') = 11

  I want to see 10.9 (or what ever the value is)

  I've tried CASTING the whole thing as both a FLOAT and a NUMERIC(3,2)

  Any ideas?

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  October 14, 2004 at 9:38 am

  #526759

  Sure!.

  Since SQL Server has no way to know a part of what month you want to calculate, the part of 28 days or a part of 31 days, you have to tell it.

  Get a number of days by DATEDIFF, divide by 365 and multiply by 12 

  Regards,Yelena Varsha

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  October 14, 2004 at 10:15 am

  #526767

  Worked out GREAT!

  Thanks