Is it possible to return derived field such as month of the date using query ent

You can't do it directly in query entity - you'd have to apply some sort of function like month() over the resulting data.

Filtering criteria will help to get subset data, does not help to query derived or calculated fields.. Any other suggestion?

You can perform simple aggregation calculations with query entity, but you can't return a derived or formatted field like you could with, say, a SQL statement. Unfortunately, as Phil outlined, you'll need to return the data then perform the manipulation you need - or create a view. Good luck!

Ok, Thanks Mike, I opted for database View option, it is easier and working good