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

This topic describes how to use the FROM_UNIXTIME function. This function returns a date of the VARCHAR type.

Limits

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

VARCHAR FROM_UNIXTIME(BIGINT unixtime, VARCHAR format)


Parameter	Data type	Description
unixtime	BIGINT	The timestamp. Unit: seconds.
format	VARCHAR	The format of logs. This parameter is optional. The default format is yyyy-MM-dd HH:mm:ss.

Note If an input parameter is NULL or a parsing error occurs, NULL is returned.

Test data


unixtime1(BIGINT)	nullstr(VARCHAR)
1505404800	NULL

Test statement

SELECT FROM_UNIXTIME(unixtime1) as var1, 
 FROM_UNIXTIME(unixtime1,'MMdd-yyyy') as var2,
 FROM_UNIXTIME(unixtime1,nullstr) as var3
FROM T1;

Test result


var1(VARCHAR)	var2(VARCHAR)	var3(VARCHAR)
2017-09-15 00:00:00	0915-2017	NULL