[
https://issues.apache.org/jira/browse/FLINK-37854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17984081#comment-17984081
]
Qilong Wang commented on FLINK-37854:
-------------------------------------
Fixed in 8937722f6fe731760ea198bd790798a69c4c1e17
> UnsupportedTemporalTypeException: Unsupported field: OffsetSeconds
> ------------------------------------------------------------------
>
> Key: FLINK-37854
> URL: https://issues.apache.org/jira/browse/FLINK-37854
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 2.1.0
> Reporter: Jacky Lau
> Priority: Major
> Fix For: 2.1.0
>
>
> spark supports, while flink doesn't
> {code:java}
> spark-sql (default)> SELECT DATE_FORMAT(CURRENT_TIMESTAMP, 'yyyy-MM-dd
> HH:mm:ssXXX');
> 2025-05-27 10:23:50+08:00
> Time taken: 4.358 seconds, Fetched 1 row(s)
> spark-sql (default)> SELECT DATE_FORMAT(CURRENT_TIMESTAMP, 'yyyy-MM-dd
> HH:mm:ssX');
> 2025-05-27 10:23:57+08
> Time taken: 0.062 seconds, Fetched 1 row(s)
> spark-sql (default)> SELECT DATE_FORMAT(CURRENT_TIMESTAMP, 'yyyy-MM-dd
> HH:mm:ssXX');
> 2025-05-27 10:24:17+0800 {code}
>
> {code:java}
> Caused by: java.time.temporal.UnsupportedTemporalTypeException: Unsupported
> field: OffsetSeconds
> at java.base/java.time.LocalDate.get0(LocalDate.java:709)
> at java.base/java.time.LocalDate.getLong(LocalDate.java:688)
> at java.base/java.time.LocalDateTime.getLong(LocalDateTime.java:718)
> at
> java.base/java.time.format.DateTimePrintContext.getValue(DateTimePrintContext.java:308)
> at
> java.base/java.time.format.DateTimeFormatterBuilder$OffsetIdPrinterParser.format(DateTimeFormatterBuilder.java:3628)
> at
> java.base/java.time.format.DateTimeFormatterBuilder$CompositePrinterParser.format(DateTimeFormatterBuilder.java:2402)
> at
> java.base/java.time.format.DateTimeFormatter.formatTo(DateTimeFormatter.java:1849)
> at
> java.base/java.time.format.DateTimeFormatter.format(DateTimeFormatter.java:1823)
> at java.base/java.time.LocalDateTime.format(LocalDateTime.java:1746)
> at
> org.apache.flink.table.utils.DateTimeUtils.formatTimestamp(DateTimeUtils.java:799)
> at
> org.apache.flink.table.utils.DateTimeUtils.formatTimestamp(DateTimeUtils.java:764)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
