Date & Time

SYSDATE

Snowflake

Mengembalikan current timestamp saat fungsi dipanggil. Berbeda dari CURRENT_TIMESTAMP yang konstan per statement.

Tipe hasil: TIMESTAMP_LTZDiperbarui: 6 Jan 2026

Syntax

SQL

SYSDATE()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT
2   CURRENT_TIMESTAMP as ct1,
3   (SELECT COUNT(*) FROM large_table),
4   CURRENT_TIMESTAMP as ct2,
5   SYSDATE() as sys;

CURRENT_TIMESTAMP sama, SYSDATE mungkin berbeda.

1	SELECT
2	CURRENT_TIMESTAMP as ct1,
3	(SELECT COUNT(*) FROM large_table),
4	CURRENT_TIMESTAMP as ct2,
5	SYSDATE() as sys;