interval-display-iso_8601.sql.out

-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 1


-- !query 0
SELECT
  cast(null as interval), -- null
  interval '0 day', -- 0
  interval '1 year', -- year only
  interval '1 month', -- month only
  interval '1 year 2 month', -- year month only
  interval '1 day -1 hours',
  interval '-1 day -1 hours',
  interval '-1 day 1 hours',
  interval '-1 days +1 hours',
  interval '1 years 2 months -3 days 4 hours 5 minutes 6.789 seconds',
  - interval '1 years 2 months -3 days 4 hours 5 minutes 6.789 seconds'
-- !query 0 schema
struct<CAST(NULL AS INTERVAL):interval,INTERVAL '0 seconds':interval,INTERVAL '1 years':interval,INTERVAL '1 months':interval,INTERVAL '1 years 2 months':interval,INTERVAL '1 days -1 hours':interval,INTERVAL '-1 days -1 hours':interval,INTERVAL '-1 days 1 hours':interval,INTERVAL '-1 days 1 hours':interval,INTERVAL '1 years 2 months -3 days 4 hours 5 minutes 6.789 seconds':interval,(- INTERVAL '1 years 2 months -3 days 4 hours 5 minutes 6.789 seconds'):interval>
-- !query 0 output
NULL	PT0S	P1Y	P1M	P1Y2M	P1DT-1H	P-1DT-1H	P-1DT1H	P-1DT1H	P1Y2M-3DT4H5M6.789S	P-1Y-2M3DT-4H-5M-6.789S