interval_sub_interval_scalar.sql 266 B

12345678910111213141516
  1. USE plato;
  2. SELECT
  3. ni - Interval("P1D"),
  4. wi - Interval("P1D"),
  5. ni - Interval64("P1D"),
  6. wi - Interval64("P1D")
  7. FROM Dates;
  8. SELECT
  9. Interval("P1D") - ni,
  10. Interval("P1D") - wi,
  11. Interval64("P1D") - ni,
  12. Interval64("P1D") - wi
  13. FROM Dates;