SQL Function Reference

FROM_UNIXTIME

Converts a Unix timestamp to a date or datetime string. Optionally formats the result.

MySQL

FROM_UNIXTIME(unix_timestamp[, format])

unix_timestamp

The Unix timestamp to convert.

format

Optional. The output format string.

Allows you to convert numeric time values back to a human-readable date and time format.

Examples

MySQL

SELECT FROM_UNIXTIME(1717584000);

MySQL

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(date))
FROM Payments;

MySQL

SELECT member_name,
	FROM_UNIXTIME(UNIX_TIMESTAMP(birthday), '%Y-%m-%d')
FROM FamilyMembers;