Skip to main content

DATE

This function parses the argument using the specified format if specified.

SYNTAX​

DATE ( arg [ , <format_modifier>,  format] )  

<format_modifier> ::=
    "FORMAT"

ARGUMENTS​

arg
A value to be converted to a date. Valid arguments are Numeric, Date & Time values, and STRINGS. If a format is specified arg must be of type STRING.

format_modifier
Specifies how the format argument should be interpreted.

format
An optional string argument to specify how the arg should be interpreted.

RETURN VALUE​

The formatted date of DATE data type.

Remarks​

  • When the arg is a numeric it is interpreted as the number of seconds since January 1, 1970 UTC.
  • If a string is provided and "FORMAT" is not specified, the default format is "2006-01-02"

Examples​

This example interprets the provided datetime string using the format provided, and converts it to a date.

SELECT DATE("2021-05-12 08:06:25", "FORMAT", "2006-01-02 15:04:05") AS formatted;

For a list of golang time formats see the time package.

Response:

FORMATTED [DATE]
2021-05-12