Get Maximum Month or the last month of the year using mysql

To Get the last month or the maximum month of the year from the table,we can use the following query,

select max(month(edate)) as Maxmonth from testdb where year(edate)='2013'


This query will retrieve the maximum month of the specified year.