Get month from date in erpnext?

1

how to get month from date in frappe python script?

2 
import datetime
	mydate = datetime.datetime.strptime('2017-12-01', '%Y-%m-%d')
	print mydate.month

>> 12
2 Likes
3

To get month of today date

import datetime
mydate= datetime.date.today()
print mydate.month
1 Like
4

and how i did it from sql builder via pypika