我目前正在努力解决这个问题。下面是一些相关的documentation
我有一个{ 2020-11-14 16:04:15 UTC }格式的时间日期列。我想以一个整数1-7的列结束,该列对应于星期几。1=星期天,7=星期六。
目前,我有一个特定日期的工作。
SELECT EXTRACT(DAYOFWEEK FROM DATE '2013-12-25') AS the_day如何将此函数应用于整个列?
谢谢你的帮助。
SQL BigQuery
发布于 2021-10-14 05:32:38
下面是示例。
WITH
org_table AS (
SELECT DATE('2013-12-25') as org_col
UNION ALL SELECT '2013-12-26'
UNION ALL SELECT '2013-12-28'
UNION ALL SELECT '2013-12-29'
)
SELECT
org_col,
EXTRACT(DAYOFWEEK FROM org_col) AS the_day
FROM org_table
ORDER BY org_col
;附注:若要应用现有查询,请替换org_table。
WITH
org_table AS (
SELECT `your_column` as org_col
FROM `your_table`
)
...发布于 2021-10-14 03:32:01
改编自日期函数“提取”文档示例2. https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions?hl=ar-YE#extract
SELECT
date,
EXTRACT(DAYOFWEEK FROM date) AS the_day
FROM UNNEST(GENERATE_DATE_ARRAY('2015-12-23', '2016-01-09')) AS date
ORDER BY date;https://stackoverflow.com/questions/69564635
复制相似问题