[CALCITE-6634] Postgres TO_TIMESTAMP: literals are not supported

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.38.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Ulrich Kramer
• Created: 18/Oct/24 06:05
• Updated: 18/Oct/24 06:05

Description

The following unit test will fail if added to PostgresqlDateTimeFormatterTest

@Test void testLiteral() throws Exception {
  final ZonedDateTime time = createDateTime(2024, 1, 1, 0, 0, 0, 0);
  assertThat(toTimestamp("2024-01-01 00:00:00" , "YYYY-MM-DD HH24:MI:SS"), is(time));
  assertThat(toTimestamp("2024-01-01T00:00:00" , "YYYY-MM-DD\"T\"HH24:MI:SS"), is(time));
}

According to the documentation postgres supports literals in format strings enclosed in double quotes.