[jira] [Created] (SPARK-51564) TIME literals in the 12hr clock format

["Max Gekk (Jira)" <ji...@apache.org>]

Max Gekk created SPARK-51564:
--------------------------------

             Summary: TIME literals in the 12hr clock format
                 Key: SPARK-51564
                 URL: https://issues.apache.org/jira/browse/SPARK-51564
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 4.1.0
            Reporter: Max Gekk


Support TIME literals in the format:

{code:sql}
TIME timeString

timeString
{ '[h]h:[m]m:[s]s[.]' |
  '[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]' } [AM | PM]
{code}
where
* h[h]: A one or two-digit hour between 00 and 23.
When AM or PM is specified, the range is 01 to 12.
* m[m]: A one or two-digit minute between 00 and 59.
* s[s]: A one or two-digit second between 00 and 59.
* [ms][ms][ms][us][us][us]: Up to 6 digits of fractional seconds.
* AM or PM: Specifies that the time is using 12hr clock where:
  * AM is used to express 00:00:00 to 11:59:59 where 12:00:00 AM is midnight 00:00:00
  * PM is used to express 12:00:00 to 23:59:59 where 12:00:00 PM is noon 12:00:00.

h4. Mapping 12 hr clock to 24 hr clock:

||12 hr clock||24 hr clock||
|12:00:00 [AM] - 12:59:59 [AM]|00:00:00 - 00:59:59|
|01:00:00 [AM] - 11:59:59 [AM]|01:00:00 - 11:59:59|
|12:00:00 PM - 12:59:59 PM|12:00:00 - 12:59:59|
|01:00:00 PM - 11:59:59 PM|13:00:00 - 23:59:50|





--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org