[
https://issues.apache.org/jira/browse/IGNITE-25314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-25314:
--------------------------------------
Epic Link: IGNITE-24676
> Sql. Cast FORMAT. Parsing of hh/h12 format is incorrect
> -------------------------------------------------------
>
> Key: IGNITE-25314
> URL: https://issues.apache.org/jira/browse/IGNITE-25314
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> 1. It is accepts time with AM/PM when it should not:
> {noformat}
> sql-cli> SELECT CAST('05:01' AS TIME FORMAT 'hh12:mi')
> ╔════════════════════════════════════════╗
> ║ CAST('05:01' AS TIME FORMAT 'hh12:mi') ║
> ╠════════════════════════════════════════╣
> ║ 05:01 ║
> ╚════════════════════════════════════════╝
> {noformat}
> 2. It fails to parse a format when the format specifies A.M./P.M.
> {noformat}
> sql-cli> SELECT CAST('05:01 p.m.' AS TIME FORMAT 'hh12:mi p.m.')
> SQL query execution error
> java.sql.SQLException: Invalid format: 'hh12:mi p.m.' for datetime string:
> '05:01 p.m.'.
> {noformat}
> Expected results:
> {noformat}
> SELECT CAST('05:01 p.m.' AS TIME FORMAT 'hh12:mi p.m.')
> UNION ALL
> SELECT CAST('05:01 a.m.' AS TIME FORMAT 'hh12:mi a.m.')
> ---
> 17:01:00
> 05:01:00
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
