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.

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

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

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