You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Pereslegin (Jira)" <ji...@apache.org> on 2024/02/20 07:51:00 UTC
[jira] [Updated] (IGNITE-21567) Sql. Conversion from TIMESTAMP to TIMESTAMP_WITH_LOCAL_TIME_ZONE trims millis
[ https://issues.apache.org/jira/browse/IGNITE-21567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Pereslegin updated IGNITE-21567:
--------------------------------------
Description:
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}
was:
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}
> 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
> Reporter: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> 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)