1、
2、截取年月日的方法:
-- 字符串截取年月日
where SUBSTR(cast(t.checkdate as string),1,10) <= '2023-02-15'
and '2023-02-01' <= SUBSTR(cast(t.checkdate as string),1,10)
-- 函数截取年,月
YEAR(CAST(t.checkdate as timestamp)) = 2023
MONTH(cast(t.checkdate as TIMESTAMP)) <=3
3、
4、
5、
6、