Maxim Gekk created SPARK-29006: ---------------------------------- Summary: Support special date/timestamp values `infinity`/`-infinity` Key: SPARK-29006 URL: https://issues.apache.org/jira/browse/SPARK-29006 Project: Spark Issue Type: Sub-task Components: SQL Affects Versions: 3.0.0 Reporter: Maxim Gekk
||Input String||Valid Types||Description|| |{{epoch}}|{{date}}, {{timestamp}}|1970-01-01 00:00:00+00 (Unix system time zero)| |{{infinity}}|{{date}}, {{timestamp}}|later than all other time stamps| |{{-infinity}}|{{date}}, {{timestamp}}|earlier than all other time stamps| |{{now}}|{{date}}, {{time}}, {{timestamp}}|current transaction's start time| |{{today}}|{{date}}, {{timestamp}}|midnight today| |{{tomorrow}}|{{date}}, {{timestamp}}|midnight tomorrow| |{{yesterday}}|{{date}}, {{timestamp}}|midnight yesterday| |{{allballs}}|{{time}}|00:00:00.00 UTC| https://www.postgresql.org/docs/12/datatype-datetime.html -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org