[jira] [Created] (IGNITE-25314) Sql. Cast FORMAT. Parsing of hh/h12 format is incorrect

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-25314:
-----------------------------------------

             Summary: 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


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 it has AM/PM.

{noformat}
sql-cli> SELECT CAST('05:01 pm' AS TIME FORMAT 'hh12:mi pm')
SQL query execution error
java.sql.SQLException: Invalid format: 'hh12:mi pm' for datetime string: '05:01 
pm'.
{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)