EXTRACT()("提取"的意思) 函数用于返回日期/时间的单独部分,比如年、月、日、小时、分钟等等。
就是返回出来具体的年,月,日
2008-12-29 16:25:46.635
SELECT EXTRACT(YEAR FROM OrderDate) AS OrderYear,
EXTRACT(MONTH FROM OrderDate) AS OrderMonth,
EXTRACT(DAY FROM OrderDate) AS OrderDay
EXTRACT(year_monthFROM OrderDate) AS ym
FROM Orders
OrderYear OrderMonth OrderDay ym
2008 12 29 200812
分组取日期
extract(day from 目标日期) over(PARTITION BY 目标年,目标月,city)
取每月天数
max(extract(day from 目标日期)) over(PARTITION BY 目标年,目标月,city) as 本月天数