[SPARK-28425] Add more Date/Time Operators - ASF JIRA

XML

Word

Printable

JSON

Operator	Example	Result
`+`	`date '2001-09-28' + interval '1 hour'`	`timestamp '2001-09-28 01:00:00'`
`-`	`date '2001-09-28' - interval '1 hour'`	`timestamp '2001-09-27 23:00:00'`
`*`	`900 * interval '1 second'`	`interval '00:15:00'`
`*`	`21 * interval '1 day'`	`interval '21 days'`
`*`	`double precision '3.5' * interval '1 hour'`	`interval '03:30:00'`
`/`	`interval '1 hour' / double precision '1.5'`	`interval '00:40:00'`

is cloned by

SPARK-29355 Support timestamps subtraction

is related to

SPARK-27898 Support 4 date operators(date + integer, integer + date, date - integer and date - date)