[
https://issues.apache.org/jira/browse/SPARK-57031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Max Gekk updated SPARK-57031:
-----------------------------
Description:
h2. What
Document the TIME-related functions and operators in the SQL function
reference, and update
the ANSI-compliance page for TIME.
h2. Content
* Function reference entries (and examples) for the TIME builtins:
{{current_time}},
{{localtime}} (SPARK-57558), {{make_time}}, {{to_time}} / {{try_to_time}},
{{hour}} /
{{minute}} / {{second}}, {{time_trunc}}, {{time_diff}}, {{time_bucket}}
(SPARK-54507),
{{time_from_*}} / {{time_to_*}}, and {{make_timestamp[_ntz|_ltz]}} with a
TIME argument.
* Operators/arithmetic: {{TIME +/- INTERVAL}}, {{TIME - TIME -> day-time
interval}},
{{EXTRACT(HOUR|MINUTE|SECOND FROM time)}}.
* ANSI-compliance page: list TIME among supported datetime types and note
deviations
(default precision 6 vs ANSI 0; TIME WITH TIME ZONE not supported).
h2. Out of scope
* The data-type reference page (covered by SPARK-57030).
h2. Note
This ticket and SPARK-57030 were near-duplicates ("Document TIME data type" /
"Docs for TIME
data type"); they are now scoped distinctly (functions/ANSI here, data-type
page there). If
the team prefers a single docs ticket, close one as a duplicate.
Summary: Document TIME functions, operators, and the ANSI compliance
page (was: Docs for TIME data type)
> Document TIME functions, operators, and the ANSI compliance page
> ----------------------------------------------------------------
>
> Key: SPARK-57031
> URL: https://issues.apache.org/jira/browse/SPARK-57031
> Project: Spark
> Issue Type: Sub-task
> Components: Documentation
> Affects Versions: 4.2.0
> Reporter: Serge Rielau
> Priority: Major
>
> h2. What
> Document the TIME-related functions and operators in the SQL function
> reference, and update
> the ANSI-compliance page for TIME.
> h2. Content
> * Function reference entries (and examples) for the TIME builtins:
> {{current_time}},
> {{localtime}} (SPARK-57558), {{make_time}}, {{to_time}} / {{try_to_time}},
> {{hour}} /
> {{minute}} / {{second}}, {{time_trunc}}, {{time_diff}}, {{time_bucket}}
> (SPARK-54507),
> {{time_from_*}} / {{time_to_*}}, and {{make_timestamp[_ntz|_ltz]}} with a
> TIME argument.
> * Operators/arithmetic: {{TIME +/- INTERVAL}}, {{TIME - TIME -> day-time
> interval}},
> {{EXTRACT(HOUR|MINUTE|SECOND FROM time)}}.
> * ANSI-compliance page: list TIME among supported datetime types and note
> deviations
> (default precision 6 vs ANSI 0; TIME WITH TIME ZONE not supported).
> h2. Out of scope
> * The data-type reference page (covered by SPARK-57030).
> h2. Note
> This ticket and SPARK-57030 were near-duplicates ("Document TIME data type" /
> "Docs for TIME
> data type"); they are now scoped distinctly (functions/ANSI here, data-type
> page there). If
> the team prefers a single docs ticket, close one as a duplicate.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
