[ https://issues.apache.org/jira/browse/SPARK-29369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan reassigned SPARK-29369: ----------------------------------- Assignee: Maxim Gekk > Accept strings without `interval` prefix in casting to intervals > ---------------------------------------------------------------- > > Key: SPARK-29369 > URL: https://issues.apache.org/jira/browse/SPARK-29369 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Maxim Gekk > Assignee: Maxim Gekk > Priority: Minor > > PostgreSQL allows strings without the `interval` prefix while casting a > string to an interval: > {code} > maxim=# select cast('1 day' as interval); > interval > ---------- > 1 day > (1 row) > maxim=# select interval '1 microsecond'; > interval > ----------------- > 00:00:00.000001 > (1 row) > {code} > See > https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-INTERVAL-INPUT -- 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