how to substract one date from another?

[shams]

hi,
i have table pharmacy with the column expiry, i need a mysql query to substract the current date from the drug expiray date and print how many months left for expiray?

[Xnuiem]

What is the field type? Date, INT? I always use INT(10) for all dates since it is so much easier to store timestamps.

[shams]

hi Xnuiem,
thanks for reply yes the column is (date INT), i don't need the timestamp, i want something that substract the y-m-d and show the result in months, any how i can change the column to int(10) if it is neccessary.