input_date32.sql 1.3 KB

123456789101112131415
  1. select 1, cast("-144170-12-31" as date32), cast(cast("-144170-12-31" as date32) as string);
  2. select 2, cast("-144169-01-01" as date32), cast(cast("-144169-01-01" as date32) as string);
  3. select 3, cast("-1-1-1" as date32), cast(cast("-1-1-1" as date32) as string);
  4. select 4, cast("0-1-1" as date32), cast(cast("0-1-1" as date32) as string);
  5. select 5, cast("1-1-1" as date32), cast(cast("1-1-1" as date32) as string);
  6. select 6, cast("1-02-29" as date32), cast(cast("1-02-29" as date32) as string);
  7. select 7, cast("1969-12-31" as date32), cast(cast("1969-12-31" as date32) as string);
  8. select 8, cast("1970-01-01" as date32), cast(cast("1970-01-01" as date32) as string);
  9. select 9, cast("2000-04-05" as date32), cast(cast("2000-04-05" as date32) as string);
  10. select 10, cast("2100-02-29" as date32), cast(cast("2100-02-29" as date32) as string);
  11. select 11, cast("2100-03-01" as date32), cast(cast("2100-03-01" as date32) as string);
  12. select 12, cast("2105-12-31" as date32), cast(cast("2105-12-31" as date32) as string);
  13. select 13, cast("2106-01-01" as date32), cast(cast("2106-01-01" as date32) as string);
  14. select 14, cast("148107-12-31" as date32), cast(cast("148107-12-31" as date32) as string);
  15. select 15, cast("148108-01-01" as date32), cast(cast("148108-01-01" as date32) as string);