Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Built-In Functions/ Date Functions/ to_date
Updated on 2023-10-25 GMT+08:00
View PDF

to_date

This function is used to return the year, month, and day in a time.

Similar function: to_date1. The to_date1 function is used to convert a string in a specified format to a date value. The date format can be specified.

Syntax

to_date(string timestamp)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

timestamp

Yes

DATE

STRING

Time to be processed

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

Return Values

The return value is of the DATE type, in the yyyy-mm-dd format.

  • If the value of timestamp is not of the DATE or STRING type, the error message "data type mismatch" is displayed.
  • If the value of timestamp is of the DATE or STRING type but is not in one of the supported formats, NULL is returned.

Example Code

The value 2023-08-16 is returned.

select to_date('2023-08-16 10:54:36');

The value NULL is returned.

select to_date(null);
Parent topic: Date Functions