<code class="language-sql">--日期转时间戳
SELECT EXTRACT(epoch FROM NOW());
SELECT EXTRACT(epoch FROM CAST('2017-12-06 00:17:10' AS TIMESTAMP));
--时间戳转日期
SELECT TO_TIMESTAMP(1512490630)</code>
– 传入时间的格式字符型,添加时分秒作为条件,使用’ ′collecttimeBETWEEN‘ ′ c o l l e c t t i m e B E T W E E N ‘ {input.startCollectDate} 00:00:00' AND '${input.endCollectDate} 23:59:59’