[ https://issues.apache.org/jira/browse/SPARK-29370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maxim Gekk updated SPARK-29370: ------------------------------- Description: In PostgreSQL, Quantities of days, hours, minutes, and seconds can be specified without explicit unit markings. For example, '1 12:59:10' is read the same as '1 day 12 hours 59 min 10 sec'. For example: {code:java} maxim=# select interval '1 12:59:10'; interval ---------------- 1 day 12:59:10 (1 row) {code} It should allow to specify the sign: {code} maxim=# SELECT interval '1 +2:03:04' minute to second; interval ---------------- 1 day 02:03:04 maxim=# SELECT interval '1 -2:03:04' minute to second; interval ----------------- 1 day -02:03:04 {code} was: In PostgreSQL, Quantities of days, hours, minutes, and seconds can be specified without explicit unit markings. For example, '1 12:59:10' is read the same as '1 day 12 hours 59 min 10 sec'. For example: {code} maxim=# select interval '1 12:59:10'; interval ---------------- 1 day 12:59:10 (1 row) {code} > Interval strings without explicit unit markings > ----------------------------------------------- > > Key: SPARK-29370 > URL: https://issues.apache.org/jira/browse/SPARK-29370 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Maxim Gekk > Priority: Major > > In PostgreSQL, Quantities of days, hours, minutes, and seconds can be > specified without explicit unit markings. For example, '1 12:59:10' is read > the same as '1 day 12 hours 59 min 10 sec'. For example: > {code:java} > maxim=# select interval '1 12:59:10'; > interval > ---------------- > 1 day 12:59:10 > (1 row) > {code} > It should allow to specify the sign: > {code} > maxim=# SELECT interval '1 +2:03:04' minute to second; > interval > ---------------- > 1 day 02:03:04 > maxim=# SELECT interval '1 -2:03:04' minute to second; > interval > ----------------- > 1 day -02:03:04 > {code} > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org