Dear all, Thank you once again, as usual i got code tips from you guys today after implementing it, this solve part of my challenges now i want to convert list of duration to duration in months Duration (int) Number of Months 30 1 month 90 3 months 60 2 months 120 4 months the script is shown below Select PatientId, VisitDate,drug_Type, Duration from PatientPhermacy i want the duration to be in number of months as in the table above. thank you all

Hi Abraham, Try this, Select PatientId, VisitDate,drug_Type, Convert(varchar(10), Duration / 30) + ' Months ' + Convert(varchar(10), Duration % 30) + ' Days' AS [Number of Months] from PatientPhermacy

Many thanks to Esakki Muthu and Aakash Morya, you guys are awesome, I appreciate you all thank you a million times. To the moderator and management of this site, you guys are wonderful to the coding communities. you are one of the best.

Select PatientId, VisitDate,drug_Type, Duration/30 'Number of Months' from PatientPhermacy This you want?

Answers

How to convert integers to numbers of months

Abraham Olatubosun

257

1 Server Controls

Dear all,

Thank you once again, as usual i got code tips from you guys today after implementing it, this solve part of my challenges now i want to convert list of duration to duration in months

Duration (int)	Number of Months
30	1 month
90	3 months
60	2 months
120	4 months

the script is shown below

Select PatientId, VisitDate,drug_Type, Duration from PatientPhermacy

i want the duration to be in number of months as in the table above.

thank you all

How to convert integers to numbers of months

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)