[FLINK-25304] TIMESTAMP/TIMESTAMP_LTZ Pad with trailing zeros for fractional seconds depending on the precision specified

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Marios Trivyzas
• Reporter: Marios Trivyzas
• Created: 14/Dec/21 12:11
• Updated: 20/Dec/21 11:04
• Resolved: 14/Dec/21 16:39

Description

Should we pad with trailing zeros for the fractional second part?

e.g.:

 

CAST(CAST('2021-12-13 11:22:33.123456' AS TIMESTAMP(9) AS STRING)

Should it return:

 

2021-12-13 11:22:33.123456

or:

2021-12-13 11:22:33.123456000

?

 

 

Issue Links

• links to: GitHub Pull Request #18106
• links to: GitHub Pull Request #18135