How do I use the YEAR function in Google BigQuery?

Description https://onelinerhub.com/google-big-query/how-do-i-use-the-year-function-in-google-bigquery
Onelinerhub · Jun 20, 2023 · d262cdc · d262cdc
1 parent b0d502c
commit d262cdc
Showing 1 changed file with 25 additions and 0 deletions.
diff --git a/google-big-query/how-do-i-use-the-year-function-in-google-bigquery.md b/google-big-query/how-do-i-use-the-year-function-in-google-bigquery.md
@@ -0,0  1,25 @@
 # How do I use the YEAR function in Google BigQuery?
 // plain
 
 The YEAR function in Google BigQuery is used to extract the year from a date or timestamp expression. It takes in one parameter, which is a date or timestamp expression. The output of the YEAR function is an integer between 1 and 9999.
 
 For example:
 ```
 SELECT YEAR('2015-06-13') as year;
 ```
 The output of this query will be:
 ```
 year
 2015
 ```
 
 The parts of the code are:
 - `SELECT`: This is a keyword used to indicate that a query is being executed
 - `YEAR('2015-06-13')`: This is the YEAR function, taking in the date '2015-06-13' as a parameter
 - `as year`: This is an alias for the output of the query, which will be stored in the column 'year'
 
 ## Helpful links
 - [Google BigQuery Documentation](https://cloud.google.com/bigquery/docs/)
 - [YEAR Function Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#date-and-time-functions)
 
 onelinerhub: [How do I use the YEAR function in Google BigQuery?](https://onelinerhub.com/google-big-query/how-do-i-use-the-year-function-in-google-bigquery)