prestoでJSTの期間指定をする雛形

presto jstのクエリ

よく使うが忘れてしまうのでメモ

SELECT
  count(*) 
FROM db_name.table_name AS t
WHERE
    time BETWEEN 
      from_unixtime(to_unixtime(timestamp '2016-01-01 00:00 UTC' ) + (15 * 3600))
    AND
      from_unixtime(to_unixtime(timestamp '2016-01-02 00:00 UTC' ) + (15 * 3600))
;