抽取的脚本写 select * from 表名没问题。
但是数据量大的表写where条件限制为什么抽过来的数据为0行。在抽数预览的时候是有数据的。但是抽到平台后查看表是空的
select * from 表名
where
--固定日期
(
(EXTRACT(MONTH FROM time) = 1 AND EXTRACT(DAY FROM time) BETWEEN 15 AND 21)
OR
(EXTRACT(MONTH FROM time) = 8 AND EXTRACT(DAY FROM time) BETWEEN 5 AND 11)
OR
(EXTRACT(MONTH FROM time) = 4 AND EXTRACT(DAY FROM time) BETWEEN 15 AND 21)
)
--取整点
AND EXTRACT(MINUTE FROM time) = 0
AND EXTRACT(SECOND FROM time) = 0
