Date & Time

TIME_SLICE

SnowflakeSnowflake

Membagi waktu ke dalam buckets/intervals dengan panjang tertentu. Berguna untuk time-series bucketing.

Tipe hasil: DATE/TIMESTAMP

Syntax

SQL
TIME_SLICE(date_or_time, slice_length, date_or_time_part [, start_or_end])

Parameter

date_or_timeDATE/TIMESTAMPwajib

Timestamp input

slice_lengthINTEGERwajib

Panjang setiap bucket

date_or_time_partVARCHARwajib

Unit: MINUTE, HOUR, DAY, WEEK, MONTH, etc.

start_or_endVARCHARopsional

'START' atau 'END' of slice (default START)

Contoh Penggunaan

15-Minute Buckets

SQL
1SELECT
2  event_time,
3  TIME_SLICE(event_time, 15, 'MINUTE') as bucket_start,
4  TIME_SLICE(event_time, 15, 'MINUTE', 'END') as bucket_end
5FROM events;

Grouping events ke dalam 15-minute buckets.

Hasil
event_timebucket_startbucket_end
2024-01-15 14:07:002024-01-15 14:00:002024-01-15 14:15:00
2024-01-15 14:23:002024-01-15 14:15:002024-01-15 14:30:00
Kembali ke Snowflake Functions