比較対象はtimestamp型に変更してから比較

1
2
3
4
5
6
7
8
SELECT
  *
FROM
  [zzzzzzzzzz.xxxxxxxxxxxxx]
WHERE
  _PARTITIONTIME between timestamp('2018-12-04') and timestamp('2018-12-11')
ORDER BY log_time DESC
LIMIT 100