Pavel Pereslegin created IGNITE-21567:
-----------------------------------------
Summary: 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
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)
