[
https://issues.apache.org/jira/browse/SPARK-51564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17941988#comment-17941988
]
Sakthi commented on SPARK-51564:
--------------------------------
Interested in working on this task.
> 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
> Priority: Major
>
> 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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
