我尝试只选择上午和下午高峰的交通数据。在Amazon Redshift中查询时间间隔数据时(如在流量高峰期),我无法获取sql: TO_TIMESTAMP(TO_CHAR(timestamp_field,'HH24:MI'),'HH21:MI')) between '0001-01-01 06:30' and '0001-01-01 09:30 去工作。它没有返回任何内容。相反,我不得不使用: EXTRACT(HOUR from timestamp_field) = 6 and EXTRACT(MINUTE from times