### SUBSTRAIT_SCALAR_TEST: v1.0
### SUBSTRAIT_INCLUDE: extension:io.substrait:functions_datetime
# timestamps: examples using the precision_timestamp type
lte('2016-12-31T13:30:15'::pts<6>, '2017-12-31T13:30:15'::pts<6>) = true::bool
lte('2017-12-31T13:30:15'::pts<6>, '2017-12-31T13:30:15'::pts<6>) = true::bool
lte('2018-12-31T13:30:15'::pts<6>, '2017-12-31T13:30:15'::pts<6>) = false::bool
# timestamp_tz: examples using the precision_timestamp_tz type
lte('1999-01-08T01:05:05-08:00'::ptstz<6>, '1999-01-08T04:05:06-05:00'::ptstz<6>) = true::bool
lte('1999-01-08T01:05:06-08:00'::ptstz<6>, '1999-01-08T01:05:06-08:00'::ptstz<6>) = true::bool
lte('1999-01-08T01:05:06-08:00'::ptstz<6>, '1999-01-08T04:05:05-05:00'::ptstz<6>) = false::bool
# date: examples using the date type
lte('2020-12-30'::date, '2020-12-31'::date) = true::bool
lte('2020-12-31'::date, '2020-12-31'::date) = true::bool
lte('2020-12-31'::date, '2020-12-30'::date) = false::bool
# interval: examples using the interval type
lte('P7D'::iday, 'P7D'::iday) = true::bool
lte('P7D'::iday, 'P6D'::iday) = false::bool
lte('P5D'::iday, 'P6D'::iday) = true::bool
lte('P5Y'::iyear, 'P6Y'::iyear) = true::bool
lte('P7Y'::iyear, 'P7Y'::iyear) = true::bool
lte('P7Y'::iyear, 'P6Y'::iyear) = false::bool
# null_input: examples with null args or return
lte(null::iday?, 'P5D'::iday) = null::bool?
lte(null::date?, '2020-12-30'::date) = null::bool?
lte(null::pts?<6>, '2018-12-31T13:30:15'::pts<6>) = null::bool?