TO_DATE - Realtime Compute for Apache Flink - Alibaba Cloud Documentation Center

The topic describes how to use the TO_DATE function. This function converts a date value from the INT or VARCHAR type to the DATE type.

Limits

This function is supported only in Realtime Compute for Apache Flink that uses Ververica Runtime (VVR) 3.0.0 or later.

Date TO_DATE(INT time)
Date TO_DATE(VARCHAR date)
Date TO_DATE(VARCHAR date,VARCHAR format)


Parameter	Data type	Description
time	INT	The number of days that have elapsed since the epoch time January 1, 1970, 00:00:00 UTC.
date	VARCHAR	The default format is yyyy-MM-dd.
format	VARCHAR	The date format.

Test data

Table 1. T1
date1(INT)	date2(VARCHAR)	date3(VARCHAR)
100	2017-09-15	20170915

Test statement

SELECT TO_DATE(date1) as var1,
 TO_DATE(date2) as var2,
 TO_DATE(date3,'yyyyMMdd') as var3
FROM T1;

Test result


var1(DATE)	var2(DATE)	var3(DATE)
1970-04-11	2017-09-15	2017-09-15