HI I am able to get the some timestamp values to Hour using below function. Select toEpochSeconds(DATETRUNC('hour', event_time)) AS hourly_event_time.. i want to get 30 minutes granularity of event_time.How can I achieved. can you provide example

I am using below function DATETRUNC('HOUR', original_event_time) + (FLOOR(EXTRACT(MINUTE FROM original_event_time) / 30) * 30 * 60) AS half_hour is there to better way to..can you provide some example please.I am not getting from documents

You can use toEpochRound kind of function