how to compare and calculate current date with db’s date ?

Question

in my table there is a column enddate i want to compare todays date with enddate in my table if enddate is greater then current date then it should return the remaining months else 0