Conversion

FROM_UNIXTIME

MySQL

Mengkonversi Unix timestamp ke DATETIME atau format string. Kebalikan dari UNIX_TIMESTAMP().

Tipe hasil: DATETIME | VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

FROM_UNIXTIME(unix_timestamp[, format])

unix_timestampBIGINTwajib

Unix timestamp (detik sejak epoch)

formatVARCHARopsional

Format output string (opsional)

SQL

1 SELECT FROM_UNIXTIME(1705320000) AS dt;

Konversi Unix timestamp ke datetime.

Hasil

dt: 2024-01-15 12:00:00

SQL

1 SELECT FROM_UNIXTIME(1705320000, '%Y-%m-%d') AS date_only;

Format output sebagai date saja.

Hasil

date_only: 2024-01-15

SQL

1 SELECT id, FROM_UNIXTIME(created_at) AS created_datetime
2 FROM api_events;

Konversi timestamp dari API.

Hasil

(readable datetimes)

TIMESTAMP_SECONDS

BigQuery

1	SELECT id, FROM_UNIXTIME(created_at) AS created_datetime
2	FROM api_events;