interval_div.sql 344 B

12345678910111213141516171819202122
  1. USE plato;
  2. SELECT
  3. a.ni / b.i8,
  4. a.wi / b.i8,
  5. a.ni / b.u8,
  6. a.wi / b.u8,
  7. a.ni / b.i16,
  8. a.wi / b.i16,
  9. a.ni / b.u16,
  10. a.wi / b.u16,
  11. a.ni / b.i32,
  12. a.wi / b.i32,
  13. a.ni / b.u32,
  14. a.wi / b.u32,
  15. a.ni / b.i64,
  16. a.wi / b.i64,
  17. a.ni / b.u64,
  18. a.wi / b.u64,
  19. FROM Dates as a CROSS JOIN Dates as b;