Conversion

EPOCH_MS

DuckDB

Mengkonversi Unix epoch dalam milidetik ke TIMESTAMP. Berguna untuk data dari JavaScript/Java.

Tipe hasil: TIMESTAMPDiperbarui: 6 Jan 2026

Syntax

SQL

EPOCH_MS(milliseconds) | TO_TIMESTAMP(milliseconds)

Parameter

millisecondsBIGINTwajib

Unix epoch dalam milidetik sejak 1970-01-01

Contoh Penggunaan

Konversi Epoch Milidetik

SQL

1 SELECT
2   ms_val,
3   EPOCH_MS(ms_val) as timestamp_val
4 FROM (
5   SELECT unnest([0, 1718452800000, 946684800000]) as ms_val
6 );

Mengkonversi epoch milliseconds ke timestamp.

Hasil

ms_val	timestamp_val
0	1970-01-01 00:00:00
1718452800000	2024-06-15 12:00:00
946684800000	2000-01-01 00:00:00

Import JavaScript Timestamps

SQL

1 SELECT
2   event_name,
3   EPOCH_MS(js_timestamp) as event_time
4 FROM js_events;

Mengkonversi timestamp dari JavaScript/frontend.

Hasil

event_name	event_time
click	2024-06-15 14:30:45.123
scroll	2024-06-15 14:30:46.456

Round-trip Conversion

SQL

1 SELECT
2   original_ts,
3   CAST(EPOCH(original_ts) * 1000 AS BIGINT) as to_ms,
4   EPOCH_MS(CAST(EPOCH(original_ts) * 1000 AS BIGINT)) as back_to_ts
5 FROM (SELECT TIMESTAMP '2024-06-15 14:30:45' as original_ts);

Konversi timestamp ke epoch ms dan kembali.

Hasil

original_ts	to_ms	back_to_ts
2024-06-15 14:30:45	1718458245000	2024-06-15 14:30:45

Kembali ke DuckDB Functions

1	SELECT
2	ms_val,
3	EPOCH_MS(ms_val) as timestamp_val
4	FROM (
5	SELECT unnest([0, 1718452800000, 946684800000]) as ms_val
6	);

1	SELECT
2	event_name,
3	EPOCH_MS(js_timestamp) as event_time
4	FROM js_events;

1	SELECT
2	original_ts,
3	CAST(EPOCH(original_ts) * 1000 AS BIGINT) as to_ms,
4	EPOCH_MS(CAST(EPOCH(original_ts) * 1000 AS BIGINT)) as back_to_ts
5	FROM (SELECT TIMESTAMP '2024-06-15 14:30:45' as original_ts);