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

Max Gekk updated SPARK-57575:
-----------------------------
    Description: 
h2. What

Support {{TimeType}} input in to_char / to_varchar so a TIME value can be 
formatted to a string
with a pattern, consistent with the planned time_format (SPARK-54588) and the 
existing
date/timestamp to_char.

h2. Scope

* Extend the to_char / ToCharacter datetime formatting path to accept 
{{TimeType}} and format
  time-of-day fields (HH/mm/ss plus fractional seconds), reusing TimeFormatter.
* Reject date-only pattern fields for a TIME input with a clear error.

h2. Relationship

* Complements time_format (SPARK-54588); the two should share the TimeFormatter 
and produce
  consistent output.

h2. Acceptance criteria

* to_char(time, fmt) formats correctly across precisions.
* Tests added in the to_char tests / string-function suites and SQL golden 
files.

> Support the TIME data type in to_char/to_varchar formatting
> -----------------------------------------------------------
>
>                 Key: SPARK-57575
>                 URL: https://issues.apache.org/jira/browse/SPARK-57575
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 4.3.0
>            Reporter: Max Gekk
>            Priority: Major
>
> h2. What
> Support {{TimeType}} input in to_char / to_varchar so a TIME value can be 
> formatted to a string
> with a pattern, consistent with the planned time_format (SPARK-54588) and the 
> existing
> date/timestamp to_char.
> h2. Scope
> * Extend the to_char / ToCharacter datetime formatting path to accept 
> {{TimeType}} and format
>   time-of-day fields (HH/mm/ss plus fractional seconds), reusing 
> TimeFormatter.
> * Reject date-only pattern fields for a TIME input with a clear error.
> h2. Relationship
> * Complements time_format (SPARK-54588); the two should share the 
> TimeFormatter and produce
>   consistent output.
> h2. Acceptance criteria
> * to_char(time, fmt) formats correctly across precisions.
> * Tests added in the to_char tests / string-function suites and SQL golden 
> files.



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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to