[
https://issues.apache.org/jira/browse/IGNITE-21567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17832792#comment-17832792
]
Pavel Pereslegin commented on IGNITE-21567:
-------------------------------------------
[~zstan], [~amashenkov],
do a review of the proposed changes, please.
> Sql. Conversion from TIMESTAMP to TIMESTAMP_WITH_LOCAL_TIME_ZONE trims millis
> -----------------------------------------------------------------------------
>
> Key: IGNITE-21567
> URL: https://issues.apache.org/jira/browse/IGNITE-21567
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Pavel Pereslegin
> Assignee: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Conversion from TIMESTAMP to TIMESTAMP_WITH_LOCAL_TIME_ZONE loses precision
> {code:java}
> String ts = "1992-01-18 02:30:00.123";
> assertQuery(format("select TIMESTAMP '{}'::TIMESTAMP WITH LOCAL TIME ZONE ",
> ts))
> .returns(LocalDateTime.parse(ts,
> DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss.SSS"))
> .atZone(ZoneId.systemDefault())
> .toInstant())
> .check();
> // Expected: 1992-01-17T22:30:00.123Z <class java.time.Instant>
> // Actual: 1992-01-17T22:30:00Z <class java.time.Instant>
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
