Android Question SQLIte days counter.

[Eme Fibonacci]

I have a table with birthdays in the format:

mm-dd (no year)

Examples: 02-31, 05-20, 12-31.

I would like a sqlite query to calculate how many days are left until the next birthday.
Even for the dates that are smaller than the present day.

I did it in B4A code but was not elegant. I belive that is the case of making only in sql.

Thanks for help.

 

[Erel]

I did it in B4A code but was not elegant.

How did you implement it? You should use DateUtils.