Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Built-In Functions/ Date Functions/ to_date1
Updated on 2024-09-29 GMT+08:00
View PDF
Share

to_date1

This function is used to convert a string in a specified format to a date value.

Similar function: to_date. The to_date function is used to return the year, month, and day in a time. The date format cannot be specified.

Syntax

to_date1(string date, string format)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

date

Yes

STRING

String to be converted

The following formats are supported:
  • yyyy-mm-dd
  • yyyy-mm-dd hh:mi:ss
  • yyyy-mm-dd hh:mi:ss.ff3

format

Yes

STRING

Format of the date to be converted

Constant of the STRING type. Extended date formats are not supported.

The value is a combination of the time unit (year, month, day, hour, minute, and second) and any character.

  • yyyy indicates the year.
  • mm indicates the month.
  • dd indicates the day.
  • hh indicates the hour.
  • mi indicates the minute.
  • ss indicates the second.

Return Values

The return value is of the STRING type.

  • If the value of date is not of the DATE or STRING type, the error message "data type mismatch" is displayed.
  • If the value of date is of the DATE or STRING type but is not in one of the supported formats, NULL is returned.
  • If the value of date is NULL, NULL is returned.
  • If the value of format is NULL, a date in the yyyy-mm-dd format is returned.

Example Code

The value 2023-08-16 10:54:36 is returned.

select to_date1('2023-08-16 10:54:36','yyyy-mm-dd hh:mi:ss');

The value 2023-08-16 00:00:00 is returned.

select to_date1('2023-08-16','yyyy-mm-dd');

The value NULL is returned.

select to_date1(null);

The value 2023-08-16 is returned.

select to_date1('2023-08-16 10:54:36');
Parent topic: Date Functions