How to calculate difference between two dates in months

[Sudarshan Reddy]

Hi
can any one tell how to calculate difference between two dates in months?

[Bauke Scholtz]

Depends on the DB used. Just consult the SQL documentation which comes along it. If you're using for example MySQL, you can use the DATEDIFF function for this.

[Sudarshan Reddy]

i am using the mysql DB

datediff function getting difference in dates but i need in months between two dates..?

[Bauke Scholtz]

Use TIMESTAMPDIFF.