Maxim Gekk created SPARK-28471: ---------------------------------- Summary: Formatting dates with negative years Key: SPARK-28471 URL: https://issues.apache.org/jira/browse/SPARK-28471 Project: Spark Issue Type: Sub-task Components: SQL Affects Versions: 2.4.3 Reporter: Maxim Gekk
While converting dates with negative years to strings, Spark skips era sub-field by default. That's can confuse users since years from BC era are mirrored to current era. For example: {code} spark-sql> select make_date(-44, 3, 15); 0045-03-15 {code} Even negative years are out of supported range by the DATE type, it would be nice to indicate the era for such dates. PostgreSQL outputs the era for such inputs: {code} # select make_date(-44, 3, 15); make_date --------------- 0044-03-15 BC (1 row) {code} -- This message was sent by Atlassian JIRA (v7.6.14#76016) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org