[jira] [Commented] (SPARK-29406) Interval output styles

["Xiao Li (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-29406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16985725#comment-16985725 ] 

Xiao Li commented on SPARK-29406:
---------------------------------

How about the other systems?

> Interval output styles
> ----------------------
>
>                 Key: SPARK-29406
>                 URL: https://issues.apache.org/jira/browse/SPARK-29406
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Maxim Gekk
>            Priority: Major
>
> The output format of the interval type can be set to one of the four styles sql_standard, postgres, postgres_verbose, or iso_8601, using the command SET intervalstyle, see
>  [https://www.postgresql.org/docs/11/datatype-datetime.html#DATATYPE-INTERVAL-OUTPUT]
> ||Style Specification||Year-Month Interval||Day-Time Interval||Mixed Interval||
> |{{sql_standard}}|1-2|3 4:05:06|-1-2 +3 -4:05:06|
> |{{postgres}}|1 year 2 mons|3 days 04:05:06|-1 year -2 mons +3 days -04:05:06|
> |{{postgres_verbose}}|@ 1 year 2 mons|@ 3 days 4 hours 5 mins 6 secs|@ 1 year 2 mons -3 days 4 hours 5 mins 6 secs ago|
> |{{iso_8601}}|P1Y2M|P3DT4H5M6S|P-1Y-2M3DT-4H-5M-6S|



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org