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

This topic describes how to use the DATE_FORMAT_TZ function. This function converts data of the timestamp type into a string of the specified type based on the specified time zone.

Limits

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

Syntax

VARCHAR DATE_FORMAT_TZ(TIMESTAMP timestamp, VARCHAR format, VARCHAR timezone)
VARCHAR DATE_FORMAT_TZ(TIMESTAMP timestamp, VARCHAR timezone)

Input parameters


Parameter	Data type	Description
timestamp	TIMESTAMP	The data type of time.
format	VARCHAR	The format of the output date. Example: yyyy-MM-dd HH:mm:ss.
timezone	VARCHAR	The time zone. Example: Asia/Shanghai.

Example

Test data


timestamp1(TIMESTAMP)	format1(VARCHAR)	timezone1(VARCHAR)
0	yyyy-MM-dd HH:mm:ss	Asia/Shanghai

Test statement

SELECT 
   DATE_FORMAT_TZ(timestamp1, format1, timezone1) as var1,
   DATE_FORMAT_TZ(timestamp1, timezone1) as var2
FROM T1;

Test result


var1(VARCHAR)	var2(VARCHAR)
1970-01-01 08:00:00	1970-01-01 08:00:00