

BigQuery(BQ) is very useful for data analysis or processing.
It is good at handling huge data. It returns summary result in short time.
We can use SQL in BigQuery. So it is familiar to RDB user.
And BQ has date type.
So you may want to extract YYYYMM year-month data from date column.
Then how can we get YYYYMM format data ?
So today I introduce about "How to get YYYYMM format from date column in BigQuery".











