您好，您可以使用Presto SQL中的日期函数来获取中秋节所在年月日和日期，具体查询语句如下：
```
SELECT
date_extract('year', date_add('day', CASE
WHEN day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) - 1 <= 0
THEN day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) + 6
ELSE day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) - 1
END + (15 - 1) * 7, date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp)))),
date_extract('month', date_add('day', CASE
WHEN day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) - 1 <= 0
THEN day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) + 6
ELSE day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) - 1
END + (15 - 1) * 7, date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp)))),
date_add('day', CASE
WHEN day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) - 1 <= 0
THEN day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) + 6
ELSE day_of_week(date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp))) - 1
END + (15 - 1) * 7, date_trunc('year', cast(date_parse('2021-09-21', '%Y-%m-%d') as timestamp'))) AS 中秋节日期
```
其中，'2021-09-21'为任意一个中秋节所在年份的某一个日期，可以根据实际情况进行修改。查询结果中，第一列为中秋节所在年份，第二列为中秋节所在月份，第三列为中秋节日期。
9万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
