Date & Time

HOUR

Snowflake

Mengekstrak komponen jam dari time atau timestamp.

Tipe hasil: NUMBERDiperbarui: 6 Jan 2026

Syntax

SQL

HOUR(time_or_timestamp)

time_or_timestampTIME/TIMESTAMPwajib

Nilai time atau timestamp

SQL

1 SELECT HOUR('14:30:00'::TIME) as hour;

Mengekstrak jam.

Hasil

SQL

1 SELECT HOUR(transaction_time) as hour, COUNT(*) as tx_count
2 FROM transactions
3 GROUP BY 1
4 ORDER BY 2 DESC;

Analisis jam sibuk.

1	SELECT HOUR(transaction_time) as hour, COUNT(*) as tx_count
2	FROM transactions
3	GROUP BY 1
4	ORDER BY 2 DESC;