mysql and select if

[dsafar]

I have been able to get the following sql to work - &quot;select if(month(policydate)<=6),month(policydate),month(policydate)-6) as mth from mytable&quot;. I would like to be able to do the following
&quot;select if(month(now()<6,(if(month(policydate)>6 ,month(policydate)-6,month(policydate))),
(if(month(policydate)<=6 ,month(policydate)+6,month(policydate))) as mth from mytable&quot;. Anyone been able to get similar syntax to work with mysql?

 

[swampBoogie]

Why not use a case expression?

select case when month(current_date) < 6 then
case when month(policydate) > 6 then
month(policydate) - 6
else
month(policydate) end
else
case when month(policydate) <= 6 then
month(policydate) + 6
else
month(policydate) end
end

It is much easier to read and it is not specific to Mysql.

 

[dsafar]

Thank you. Great solution.