The Arrow Spec contains an Interval type (spec link).

The primary usecase of this type is date/time arithmetic "now() - 1 month", or "2023-03-01 + 3 hours", etc

The Rust implementation has some support for this type (see https://docs.rs/arrow/35.0.0/arrow/?search=Interval).

This ticket tracks additional support for this type

https://docs.rs/arrow/35.0.0/arrow/datatypes/enum.IntervalUnit.html

This ticket is meant to supercede #527

Features:

• Support for casting Utf8 and LargeUtf8 --> Interval #3762
• Add support for adding intervals to dates #2031
• Add datatime/interval/duration into comparison kernels #3729
• Support casting to/from different interval units (eg YearDay --> MonthDayNano, etc) #3959
• Use Fixed Point Arithmetic in Interval Parsing #3809
• Support casting to/from Interval and Duration #3998
• Support Date32/Date64 minus Interval #3962
• Support Timestamp +/- Interval types #3963
• Subtracting Timestamp from Timestamp should produce a Duration (not Timestamp)  #3964
• Add datatime/interval/duration into comparison kernels #3729

Related to DataFusion apache/datafusion#5753