[FLINK-30716] [Flink SQL] SQL function TO_TIMESTAMP(string1[, string2])'s result incorrect where string2 is default: 'yyyy-MM-dd HH:mm:ss'

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 1.11.2
• Component/s: Table SQL / Runtime
• Flags: Patch

Language

sql

• Assignee: Unassigned
• Reporter: Jett Dai
• Created: 17/Jan/23 11:50
• Updated: 17/Jan/23 14:35
• Resolved: 17/Jan/23 12:01

Description

A sql statement [

select to_timestamp('2017-11-27 00:00:00')

] using funcation to_timestamp for parsing string date is executed, the result is 2017-11-27T00:00 when flink version 1.11.2, and yet it's correct where flink version 1.15.