[
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:45 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.
As a workaround, custom function can be used to convert types.
was (Author: amashenkov):
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.
> 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)
