Android Question SQLIte days counter.

Eme Fibonacci

Well-Known Member
Licensed User
Longtime User
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.
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…