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: [email protected]
For additional commands, e-mail: [email protected]
