Format a timestamp as a date and time

Syntax

FORMAT_TIME(…string-expr…, …num-expr…)

Typing

STRING -> num -> STRING

Description

FORMAT_TIME turns a timestamp (second operand) into a string formatted according to a given template (first operand).

The template, which need not be a literal string, can contain special character sequences that will be replaced with date and time elements from the timestamp.

The special sequences and what they stand for:

• %Y: year (4 digits)
• %d: day of month (2 digits)
• %H: hour of day (2 digits)
• %j: day of year
• %M: minutes in hour (2 digits)
• %m: month number (2 digits)
• %n: newline
• %t: tabulation
• %S: seconds in minute (with millisecond resolution)
• %s: the timestamp
• %u: day of week (as a number, 0 being Sunday)

Examples

See Also