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

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

     [ https://issues.apache.org/jira/browse/SPARK-51564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Max Gekk reassigned SPARK-51564:
--------------------------------

    Assignee: Uroš Bojanić

> 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
>            Assignee: Uroš Bojanić
>            Priority: Major
>              Labels: pull-request-available
>
> 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