[FLINK-24446] Casting from STRING to TIMESTAMP_LTZ looses fractional seconds

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Labels: pull-request-available
• Release Note: STRING to TIMESTAMP(_LTZ) casting now considers fractional seconds. Before fractional seconds of any precision were ignored.
• Assignee: Francesco Guardiani
• Reporter: Marios Trivyzas
• Created: 04/Oct/21 10:29
• Updated: 22/Feb/22 17:22
• Resolved: 22/Feb/22 17:22

Description

Currently the method toTimestamp(str, tz) from SqlDateTimeUtils doesn't accept more then 23 chars in the input and it also return a long which is the millis since epoch so the rest of the fractional secs are ignored.

Issue Links

• links to: GitHub Pull Request #17899
• links to: GitHub Pull Request #18632