You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Patrick Grandjean (Jira)" <ji...@apache.org> on 2022/12/16 16:06:00 UTC

[jira] [Created] (SPARK-41549) Create a TIME data type

Patrick Grandjean created SPARK-41549:
-----------------------------------------

             Summary: Create a TIME data type
                 Key: SPARK-41549
                 URL: https://issues.apache.org/jira/browse/SPARK-41549
             Project: Spark
          Issue Type: Wish
          Components: SQL
    Affects Versions: 3.3.1
            Reporter: Patrick Grandjean


As a user of Spark SQL, I wish there was a {{TIME}} data type representing a time of day.

Spark has recently added support for a {{DATE}} data type, backed by both {{java.sql.Date}} and {{java.time.LocalDate}} Java types. The new {{TIME}} data type would be backed by {{java.time.LocalTime}}.

Today, the only alternative is to use {{TIMESTAMP}}. However, displaying rows with TIMESTAMP still shows a date in 1970 (ex: {{1970-01-01 18:20:00}}) which is both confusing and less readable.




--
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