[FLINK-24423] Cast from TIME to TIMESTAMP currently uses Epoch Date

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Marios Trivyzas
• Created: 30/Sep/21 10:17
• Updated: 22/Feb/22 16:56

Description

.from(TIME(5), LocalTime.parse("12:34:56.1234567")).resultsIn(LocalDateTime.of(1970, 1, 1, 12, 34, 56, 0))

 

PostgreSQL doesn't allow such a cast, whereas Oracle uses the current system Date of the server.

 

Should we keep it as is, or zero out the year? so end up with: 

LocalDateTime.of(0, 1, 1, 12, 34, 56, 0))