select records monthwise from database sql query

SELECT ID, fromDate, toDate
FROM  SessionSchedule
WHERE (DATEPART(m, fromDate) = 8)

8- august month