x
Solved

# How to convert years into months

Posted on 2008-10-01
Medium Priority
763 Views
In my database i have two fields, period and term, sometimes period is right, but sometimes not

if period has months, then leave it
but if period has something ele in it then that needs to be converted into months etc years,days,weeks

for example
Period             Term
years               3

so, in this case term needs to be 36

any ideas....

0
Question by:fahVB

LVL 143

Expert Comment

ID: 22618711
if period = days, and term = 1 for example, what do you want to be the output?

meanwhile, check out the CASE statement...
0

LVL 60

Assisted Solution

chapmandew earned 960 total points
ID: 22618742
some sort of case statement should suffice:

select case period when years then term * 12
when days then term /31
end
from table

There are more calculations to work in there, but this shoudl get you started on one way to do this.  Maybe put the case in a function to use later.
0

LVL 39

Accepted Solution

BrandonGalderisi earned 1040 total points
ID: 22618766

Just make sure you put 'years' or 'months' in quotes since it's a string.

select case period when 'years' then term * 12
when 'Months' then term
end
from table

0

Author Comment

ID: 22618872
if period = days, and term = 1------this never happens
0

Author Comment

ID: 22618887
angelIII, there is no case stmt
0

Author Comment

ID: 22618918
0

LVL 39

Expert Comment

ID: 22618973
Trying to translate everything into a larger unit of measure is tough.  How many months is 7 weeks?  2?  What if it spans from end of april to the beginning of june?  Is that still 2?
0

Author Closing Comment

ID: 31502156
Thank you
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.