Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
3.1.0
-
None
-
None
Description
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' |
Attachments
Issue Links
- is cloned by
-
SPARK-29355 Support timestamps subtraction
- Resolved
- is related to
-
SPARK-27898 Support 4 date operators(date + integer, integer + date, date - integer and date - date)
- Resolved