Extract Month and Year from date in Bigquery
You can just use the
SELECT FORMAT_DATETIME("%B, %Y", DATETIME "2018-05-09 15:30:00") FROM yourTable;
This should print
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds