[php_mysql] Number of days to a birthday

[Charlie Markwick]

In a field called BirthDate I have a date stored as an integer in
UnixTimeStamp format.

Is it possible to perform a select statement that returned the number of
days to the next birthday.

So if the date today is 22nd November 2007 (UnixTimeStamp 1195712940)
then return:-

2 if BirthDate was 24th November 1980 (UnixTimeStamp 343872000)
363 if BirthDate was 20th November 1980 (UnixTimeStamp 343526400)

Charlie