[
https://issues.apache.org/jira/browse/IGNITE-4172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrew Mashenkov updated IGNITE-4172:
-------------------------------------
Description:
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;
Startpoint is IgniteH2Indexing.wrap() method.
We need add support to these classes: LocalDate, LocalTime, LocalDateTime.
was:
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.
> 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;
> Startpoint is IgniteH2Indexing.wrap() method.
> We need add support to these classes: LocalDate, LocalTime, LocalDateTime.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
