regress/sql/horology.sql

44 SELECT timestamp with time zone '12.27.2001 04:05:06.789-08';
58 SELECT time with time zone 'T040506.789 +08';
82 SELECT timestamp without time zone '1996-03-01' - interval '1 second' AS "Feb 29";
99 SELECT (timestamp without time zone 'tomorrow 16:00:00' = (timestamp without time zone 'today' + in…
131 SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
149 SELECT CAST(time '01:02' AS interval) AS "+01:02";
182 SELECT t.f1 AS t, i.f1 AS i, t.f1 + i.f1 AS "add", t.f1 - i.f1 AS "subtract"
197 SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
229 SELECT (time '00:00', interval '1 hour')
246   SELECT d1 FROM TIMESTAMP_TBL
247   WHERE d1 BETWEEN '13-jun-1957' AND '1-jan-1997'
279   WHERE f1 <> timestamp 'now'
296 -- This conversion may work depending on timezone
327 SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL;
345 SET DateStyle TO 'European,SQL';
377 SELECT to_timestamp('05121445482000', 'MMDDHH24MISSYYYY');
393 SELECT to_timestamp('1997 AD 11 16', 'YYYY BC MM DD');
425 SELECT to_timestamp('  20050302', 'YYYYMMDD');
443 SELECT i, to_timestamp('2018-11-02 12:34:56', 'YYYY-MM-DD HH24:MI:SS.FF' || i) FROM generate_series…