I get the following problem: My users register on my website and enter a date of birth into the database (Mysql, DATETIME field).
Now I would like to create a query that shows the upcoming birthdays within X days. For example:
name [varchar(25)] :Tim
birthday [DATETIME] : 1984-01-23
How can I create a query that shows that I have my birthday in 7 days, example: "Tim will be 30 in 7 days"
The problem I'm facing is the YEAR in the datetime field, can anyone help me?
Thanks in advance!