[ https://issues.apache.org/jira/browse/IGNITE-15622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17833475#comment-17833475 ]
Pavel Pereslegin edited comment on IGNITE-15622 at 4/3/24 9:49 AM: ------------------------------------------------------------------- Fixed in IGNITE-21567 was (Author: xtern): Resolved in IGNITE-21567 > Calcite. TIME and TIMESTAMP types are trim milliseconds. > -------------------------------------------------------- > > Key: IGNITE-15622 > URL: https://issues.apache.org/jira/browse/IGNITE-15622 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Evgeny Stanilovsky > Assignee: Pavel Pereslegin > Priority: Major > Labels: calcite, calcite2-required, calcite3-required, ignite-3 > > for example ^ > {noformat} > query I > SELECT '1969-01-01 01:03:20.45432'::TIMESTAMP::VARCHAR > ---- > 1969-01-01 01:03:20.45432 > expected=1969-01-01 01:03:20.45432, actual=1969-01-01 01:03:20 > {noformat} > {noformat} > query I > SELECT '14:42:04.35'::TIME::VARCHAR > ---- > 14:42:04.35 > expected=14:42:04.35, actual=14:42:04 > {noformat} > {noformat} > /sql/types/timestamp/bc_timestamp.test[_ignore] > /sql/types/time/time_parsing.test > {noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)