horology.out

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

 11:59:00
 23:59:00
 12:01:00
 17:00:00
 12:00:00
 12:00:00
 12:00:00
 11:59:46
 14:03:04
 12:00:00
 12:00:00
 00:00:00
 12:02:00
 17:01:00
 12:01:00
 12:01:00
 12:01:00
 12:00:46
 14:04:04
 12:01:00
 12:01:00
 00:01:00
 00:00:00
 04:59:00
 23:59:00
 23:59:00
 23:59:00
 23:58:46
 02:02:04
 23:59:00
 23:59:00
 11:59:00
 00:00:59.99
 04:59:59.99
 23:59:59.99
 23:59:59.99
 23:59:59.99
 23:59:45.99
 02:03:03.99
 23:59:59.99
 23:59:59.99
 11:59:59.99
(80 rows)

SELECT t.f1 - i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
     80      
-------------
 23:59:00
 19:00:00
 00:00:00
 00:00:00
 00:00:00
 00:00:14
 21:56:56
 00:00:00
 00:00:00
 12:00:00
 00:59:00
 20:00:00
 01:00:00
 01:00:00
 01:00:00
 01:00:14
 22:56:56
 01:00:00
 01:00:00
 13:00:00
 02:02:00
 21:03:00
 02:03:00
 02:03:00
 02:03:00
 02:03:14
 23:59:56
 02:03:00
 02:03:00
 14:03:00
 11:58:00
 06:59:00
 11:59:00
 11:59:00
 11:59:00
 11:59:14
 09:55:56
 11:59:00
 11:59:00
 23:59:00
 11:59:00
 07:00:00
 12:00:00
 12:00:00
 12:00:00
 12:00:14
 09:56:56
 12:00:00
 12:00:00
 00:00:00
 12:00:00
 07:01:00
 12:01:00
 12:01:00
 12:01:00
 12:01:14
 09:57:56
 12:01:00
 12:01:00
 00:01:00
 23:58:00
 18:59:00
 23:59:00
 23:59:00
 23:59:00
 23:59:14
 21:55:56
 23:59:00
 23:59:00
 11:59:00
 23:58:59.99
 18:59:59.99
 23:59:59.99
 23:59:59.99
 23:59:59.99
 00:00:13.99
 21:56:55.99
 23:59:59.99
 23:59:59.99
 11:59:59.99
(80 rows)

SELECT t.f1 + i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
      100       
----------------
 00:02:00-07
 05:01:00-07
 00:01:00-07
 00:01:00-07
 00:01:00-07
 00:00:46-07
 02:04:04-07
 00:01:00-07
 00:01:00-07
 12:01:00-07
 01:01:00-07
 06:00:00-07
 01:00:00-07
 01:00:00-07
 01:00:00-07
 00:59:46-07
 03:03:04-07
 01:00:00-07
 01:00:00-07
 13:00:00-07
 02:04:00-07
 07:03:00-07
 02:03:00-07
 02:03:00-07
 02:03:00-07
 02:02:46-07
 04:06:04-07
 02:03:00-07
 02:03:00-07
 14:03:00-07
 07:08:00-08
 12:07:00-08
 07:07:00-08
 07:07:00-08
 07:07:00-08
 07:06:46-08
 09:10:04-08
 07:07:00-08
 07:07:00-08
 19:07:00-08
 08:09:00-04
 13:08:00-04
 08:08:00-04
 08:08:00-04
 08:08:00-04
 08:07:46-04
 10:11:04-04
 08:08:00-04
 08:08:00-04
 20:08:00-04
 12:00:00-07
 16:59:00-07
 11:59:00-07
 11:59:00-07
 11:59:00-07
 11:58:46-07
 14:02:04-07
 11:59:00-07
 11:59:00-07
 23:59:00-07
 12:01:00-07
 17:00:00-07
 12:00:00-07
 12:00:00-07
 12:00:00-07
 11:59:46-07
 14:03:04-07
 12:00:00-07
 12:00:00-07
 00:00:00-07
 12:02:00-07
 17:01:00-07
 12:01:00-07
 12:01:00-07
 12:01:00-07
 12:00:46-07
 14:04:04-07
 12:01:00-07
 12:01:00-07
 00:01:00-07
 00:00:00-07
 04:59:00-07
 23:59:00-07
 23:59:00-07
 23:59:00-07
 23:58:46-07
 02:02:04-07
 23:59:00-07
 23:59:00-07
 11:59:00-07
 00:00:59.99-07
 04:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 23:59:45.99-07
 02:03:03.99-07
 23:59:59.99-07
 23:59:59.99-07
 11:59:59.99-07
(100 rows)

SELECT t.f1 - i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
      100       
----------------
 00:00:00-07
 19:01:00-07
 00:01:00-07
 00:01:00-07
 00:01:00-07
 00:01:14-07
 21:57:56-07
 00:01:00-07
 00:01:00-07
 12:01:00-07
 00:59:00-07
 20:00:00-07
 01:00:00-07
 01:00:00-07
 01:00:00-07
 01:00:14-07
 22:56:56-07
 01:00:00-07
 01:00:00-07
 13:00:00-07
 02:02:00-07
 21:03:00-07
 02:03:00-07
 02:03:00-07
 02:03:00-07
 02:03:14-07
 23:59:56-07
 02:03:00-07
 02:03:00-07
 14:03:00-07
 07:06:00-08
 02:07:00-08
 07:07:00-08
 07:07:00-08
 07:07:00-08
 07:07:14-08
 05:03:56-08
 07:07:00-08
 07:07:00-08
 19:07:00-08
 08:07:00-04
 03:08:00-04
 08:08:00-04
 08:08:00-04
 08:08:00-04
 08:08:14-04
 06:04:56-04
 08:08:00-04
 08:08:00-04
 20:08:00-04
 11:58:00-07
 06:59:00-07
 11:59:00-07
 11:59:00-07
 11:59:00-07
 11:59:14-07
 09:55:56-07
 11:59:00-07
 11:59:00-07
 23:59:00-07
 11:59:00-07
 07:00:00-07
 12:00:00-07
 12:00:00-07
 12:00:00-07
 12:00:14-07
 09:56:56-07
 12:00:00-07
 12:00:00-07
 00:00:00-07
 12:00:00-07
 07:01:00-07
 12:01:00-07
 12:01:00-07
 12:01:00-07
 12:01:14-07
 09:57:56-07
 12:01:00-07
 12:01:00-07
 00:01:00-07
 23:58:00-07
 18:59:00-07
 23:59:00-07
 23:59:00-07
 23:59:00-07
 23:59:14-07
 21:55:56-07
 23:59:00-07
 23:59:00-07
 11:59:00-07
 23:58:59.99-07
 18:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 00:00:13.99-07
 21:56:55.99-07
 23:59:59.99-07
 23:59:59.99-07
 11:59:59.99-07
(100 rows)

-- SQL9x OVERLAPS operator
-- test with time zone
SELECT (timestamp with time zone '2000-11-27', timestamp with time zone '2000-11-28')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "True";
 True 
------
 t
(1 row)

SELECT (timestamp with time zone '2000-11-26', timestamp with time zone '2000-11-27')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "False";
 False 
-------
 f
(1 row)

SELECT (timestamp with time zone '2000-11-27', timestamp with time zone '2000-11-28')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', interval '1 day') AS "True";
 True 
------
 t
(1 row)

SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "False";
 False 
-------
 f
(1 row)

SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp with time zone '2000-11-27', interval '12 hours') AS "True";
 True 
------
 t
(1 row)