TO_DATE()

Description

TO_DATE() returns a DATETIME value if the format string contains both date and time parts, or a DATE or TIME value if the string contains only date or time parts.

Syntax

  1. > TO_DATE(str,format)

Arguments

ArgumentsDescription
strRequired.
If the date, time, or datetime value extracted from str is illegal, STR_TO_DATE() returns NULL and produces a warning.
If str is NULL, the function returns NULL.
formatRequired. A format string indicating the format of the return value.
If the format is omitted, this function returns a DATETIME value.
If the format is NULL, this function returns NULL.
If the format is supplied, the value returned is a VARCHAR.

note

The format string can contain literal characters and format specifiers beginning with %. Literal characters in format must match literally in str. Format specifiers in format must match a date or time part in str.

Examples

  1. mysql> SELECT TO_DATE('2022-01-06 10:20:30','%Y-%m-%d %H:%i:%s') as result;
  2. +---------------------+
  3. | result |
  4. +---------------------+
  5. | 2022-01-06 10:20:30 |
  6. +---------------------+
  7. 1 row in set (0.00 sec)

Constraints

The date type supports only yyyy-mm-dd and yyyymmdd for now.