Syntax
DATE(timestamp, format)
Examples
Input |
|
Formula |
|
Output |
|
Input |
|
Formula |
|
Output |
|
Unix timestamps are supported, and can be converted to ISO8601 as follows:
Input |
|
Formula |
|
Output |
|
Many different types of textual representations of dates are supported:
Input |
|
Formula |
|
Output |
|
To get the current time, pass the special word `"now"` (or `"today"`):
Formula |
|
Output |
|