数智融合计算服务 DATAARTSFABRIC-time_format:yearweek(date[, mode])
时间:2025-06-17 08:50:04
yearweek(date[, mode])
描述:返回给定日期date在本年中对应的年份和周数,周数范围为[1, 53]。
返回值类型:integer
示例:
1 2 3 4 5 6 7 8 9 10 11 |
select yearweek('2019-12-31'); yearweek ---------- 201952 (1 row) select yearweek('2019-1-1'); yearweek ---------- 201852 (1 row) |
support.huaweicloud.com/devg-fabric/dataartsfabric_sql_04_0213.html