[jira] [Resolved] (SPARK-57575) Support the TIME data type in to_char/to_varchar formatting

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

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

Max Gekk resolved SPARK-57575.
------------------------------
    Fix Version/s: 4.3.0
       Resolution: Fixed

Issue resolved by pull request 56637
[https://github.com/apache/spark/pull/56637]

> 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
>            Assignee: Shrirang Mhalgi
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.3.0
>
>
> 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org