Conversion

MAKE_TIMESTAMP

DuckDB

Membuat nilai TIMESTAMP dari semua komponen tanggal dan waktu yang terpisah.

Tipe hasil: TIMESTAMPDiperbarui: 6 Jan 2026

Syntax

SQL

MAKE_TIMESTAMP(year, month, day, hour, minute, second)

yearINTEGERwajib

Tahun

monthINTEGERwajib

Bulan (1-12)

dayINTEGERwajib

Hari (1-31)

hourINTEGERwajib

Jam (0-23)

minuteINTEGERwajib

Menit (0-59)

secondDOUBLEwajib

Detik (0-59, dengan desimal untuk microseconds)

SQL

1 SELECT
2   MAKE_TIMESTAMP(2024, 6, 15, 14, 30, 45) as ts,
3   MAKE_TIMESTAMP(2024, 12, 31, 23, 59, 59.999) as year_end;

Membuat timestamp dari semua komponen.

Hasil

ts	year_end
2024-06-15 14:30:45	2024-12-31 23:59:59.999

SQL

1 SELECT
2   MAKE_TIMESTAMP(year, month, day, hour, minute, 0) as event_time
3 FROM legacy_events
4 WHERE year = 2024;

Konstruksi timestamp dari data legacy.

Hasil

SQL

1 SELECT MAKE_TIMESTAMP(2024, 1, day_num, 0, 0, 0) as january_days
2 FROM (SELECT unnest(range(1, 32)) as day_num);

Membuat timestamp untuk setiap hari di Januari 2024.

Hasil

1	SELECT
2	MAKE_TIMESTAMP(year, month, day, hour, minute, 0) as event_time
3	FROM legacy_events
4	WHERE year = 2024;

1	SELECT MAKE_TIMESTAMP(2024, 1, day_num, 0, 0, 0) as january_days
2	FROM (SELECT unnest(range(1, 32)) as day_num);