[
https://issues.apache.org/jira/browse/IGNITE-4172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15644417#comment-15644417
]
Andrew Mashenkov edited comment on IGNITE-4172 at 11/8/16 9:42 AM:
-------------------------------------------------------------------
I've changed IgniteH2Indexing.wrap() method to support LocalDateTime class. But
query result contains java.sql.TimeStamp objects instead of
java.time.LocalDateTime, due to H2 does not support java8 time api.
Java8 time objects support will be added in next H2 version.
To resolve this we need to update H2 version, so this ticket is deferred to
ignite 2.0.
was (Author: amashenkov):
I've changed IgniteH2Indexing.wrap() method to support LocalDateTime class. All
works fine for me.
But SQL query result contains java.sql.TimeStamp objects instead of
java.time.LocalDateTime, that may be not obvious to user.
In H2 future version java8 time objects support will be added. I saw H2 code
and it seems we will face same issue after update dependency.
Thoughts?
> SQL: Add support for Java 8 Time API classes in date\time functions
> -------------------------------------------------------------------
>
> Key: IGNITE-4172
> URL: https://issues.apache.org/jira/browse/IGNITE-4172
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 1.6, 1.7
> Reporter: Andrew Mashenkov
> Assignee: Andrew Mashenkov
> Fix For: 2.0
>
>
> We have is issue with querying LocalDateTime objects with our SQL engine.
> Next query can fails with error, if one of row localDateTimeField value has
> zero-time:
> select DATEDIFF('DAY', localDateTimeField, CURRENT_DATE ()) from t;
> It seems H2 do not support ISO-8601 short time format "HH:mm". We need
> workaround here.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
