Need help to calculate Month in integer into Year and Month

• Adelia

  SSC-Addicted

  Points: 422

  More actions

  January 16, 2022 at 10:50 am

  Go to Answer

  #3973629

  Hi,

  I've this,

  declare @t1 table ( Id int primary key, HowManyMonth int);
  
  insert into @t1(Id, HowManyMonth) values(1, 17);
  
  insert into @t1(Id, HowManyMonth) values(2, 37);
  

  How to make it output like this?

  Id | PeriodDisplay
  ------------------------
  1 | 1 Year(s), 5 Month(s)
  2 | 3 Year(s), 1 Month(s)

  Please help

  • This topic was modified 2 years, 11 months ago by  Adelia.
  • This topic was modified 2 years, 11 months ago by  Adelia.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  January 16, 2022 at 11:44 am

  Answer

  #3973639

  So you will want to use modulus %

  so months/12 to get the years then months%12 to get the remainder then you can format it how you like.

• Adelia

  SSC-Addicted

  Points: 422

  More actions

  January 16, 2022 at 9:18 pm

  #3973707

  Thanks. It workable