Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 2017/10/10一日分取る場合
- -- timeカラムはunixtime
- where _PARTITIONTIME between timestamp('2017-10-10') and timestamp('2017-10-11')
- and cast(time as timestamp) between timestamp('2017-10-10 00:00:00 +09:00') and timestamp('2017-10-10 23:59:59 +09:00')
Add Comment
Please, Sign In to add comment