Extract Month and Year from date in Bigquery

 

You can just use the FORMAT_DATETIME function:

SELECT

    FORMAT_DATETIME("%B, %Y", DATETIME "2018-05-09 15:30:00")

FROM yourTable;