Conversion
Snowflake
TO_TIMESTAMP
SnowflakeMengkonversi string, integer, atau date ke tipe TIMESTAMP.
Tipe hasil:
TIMESTAMP_NTZDiperbarui: 6 Jan 2026Syntax
SQL
TO_TIMESTAMP(expression [, format])Parameter
expressionVARCHAR/INTEGER/DATEwajib
Nilai untuk dikonversi
formatVARCHARopsional
Format string (opsional)
Contoh Penggunaan
From String
SQL
1 SELECT TO_TIMESTAMP('2024-03-15 14:30:00') as ts;
Konversi string ke timestamp.
From Unix Epoch
SQL
1 SELECT TO_TIMESTAMP(1710510600) as ts;
Konversi Unix timestamp.
Hasil
2024-03-15 14:30:00