[
https://issues.apache.org/jira/browse/IGNITE-4172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15644417#comment-15644417
]
Andrew Mashenkov commented on IGNITE-4172:
------------------------------------------
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)
