Skip to main content

FORMATDATE

Formats a AnyDB timestamp into a human-readable date string.

Syntax

FORMATDATE(timestamp, format, [timezone])

Arguments

timestamp: The Unix timestamp in seconds.
format: A format string compatible with Day.js (e.g., "YYYY-MM-DD HH:mm:ss").
timezone (optional): IANA timezone string (e.g., "UTC", "America/New_York"). Defaults to "UTC".

Example

FORMATDATE(TODAY(), "YYYY-MM-DD HH:mm:ss") → "2025-09-19 15:47:46"
FORMATDATE(1758306466, "YYMMDD", "America/New_York") → "250919"