[SPARK-28259] Date/Time Output Styles and Date Order Conventions

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 05/Jul/19 12:29
• Updated: 29/Mar/20 02:24

Description

Date/Time Output Styles

Style Specification	Description	Example
ISO	ISO 8601, SQL standard	1997-12-17 07:37:16-08
SQL	traditional style	12/17/1997 07:37:16.00 PST
Postgres	original style	Wed Dec 17 07:37:16 1997 PST
German	regional style	17.12.1997 07:37:16.00 PST

https://www.postgresql.org/docs/11/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT-TABLE

 

Date Order Conventions

datestyle Setting	Input Ordering	Example Output
SQL, DMY	day/month/year	17/12/1997 15:37:16.00 CET
SQL, MDY	month/day/year	12/17/1997 07:37:16.00 PST
Postgres, DMY	day/month/year	Wed 17 Dec 07:37:16 1997 PST

https://www.postgresql.org/docs/11/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT2-TABLE