[FLINK-32871] Support BuiltInMethod TO_TIMESTAMP with timezone options

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 2.0.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: xy
• Created: 15/Aug/23 11:26
• Updated: 10/Jul/24 06:57

Description

Support BuiltInMethod TO_TIMESTAMP with timezone options，TO_TIMESTAMPS now only use utc timezone，but many scenarios we need timzone to choose，so need a pr to support it as TO_TIMESTAMP('2023-08-10', 'yyyy-MM-dd', 'Asia/Shanghai')

this scenario in presto，starrocks，trino：

as presto,trino,starrocks:
SELECT timestamp '2012-10-31 01:00 UTC' AT TIME ZONE 'America/Los_Angeles';
2012-10-30 18:00:00.000 America/Los_Angeles

so we maybe need this function in to_timestamps

Issue Links

• duplicates: FLINK-33594 Support BuiltInMethod TO_TIMESTAMP with timezone options
• links to: GitHub Pull Request #23220
• links to: GitHub Pull Request #23754