horology.out

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

    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:00 1996 PST
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 09:32:01 1996 PST
    | Sat Feb 10 09:32:01 1996 PST
    | Sat Feb 10 09:32:01 1996 PST
    | Mon Jun 10 18:32:01 1996 PDT
    | Sat Feb 10 17:32:01 1996 PST
    | Sun Feb 11 17:32:01 1996 PST
    | Mon Feb 12 17:32:01 1996 PST
    | Tue Feb 13 17:32:01 1996 PST
    | Wed Feb 14 17:32:01 1996 PST
    | Thu Feb 15 17:32:01 1996 PST
    | Fri Feb 16 17:32:01 1996 PST
    | Mon Feb 16 17:32:01 0098 PST BC
    | Thu Feb 16 17:32:01 0096 PST
    | Tue Feb 16 17:32:01 0596 PST
    | Sun Feb 16 17:32:01 1096 PST
    | Thu Feb 16 17:32:01 1696 PST
    | Tue Feb 16 17:32:01 1796 PST
    | Sun Feb 16 17:32:01 1896 PST
    | Fri Feb 16 17:32:01 1996 PST
    | Thu Feb 16 17:32:01 2096 PST
    | Tue Feb 28 17:32:01 1995 PST
    | Tue Feb 28 17:32:01 1995 PST
    | Wed Mar 01 17:32:01 1995 PST
    | Sat Dec 30 17:32:01 1995 PST
    | Sun Dec 31 17:32:01 1995 PST
    | Mon Jan 01 17:32:01 1996 PST
    | Wed Feb 28 17:32:01 1996 PST
    | Fri Mar 01 17:32:01 1996 PST
    | Mon Dec 30 17:32:01 1996 PST
    | Tue Dec 31 17:32:01 1996 PST
    | Thu Dec 31 17:32:01 1998 PST
    | Fri Jan 01 17:32:01 1999 PST
    | Fri Dec 31 17:32:01 1999 PST
    | Sat Jan 01 17:32:01 2000 PST
(64 rows)

--
-- time, interval arithmetic
--
SELECT CAST(time '01:02' AS interval) AS "+01:02";
     +01:02      
-----------------
 @ 1 hour 2 mins
(1 row)

SELECT CAST(interval '02:03' AS time) AS "02:03:00";
 02:03:00 
----------
 02:03:00
(1 row)

SELECT time '01:30' + interval '02:01' AS "03:31:00";
 03:31:00 
----------
 03:31:00
(1 row)

SELECT time '01:30' - interval '02:01' AS "23:29:00";
 23:29:00 
----------
 23:29:00
(1 row)

SELECT time '02:30' + interval '36:01' AS "14:31:00";
 14:31:00 
----------
 14:31:00
(1 row)

SELECT time '03:30' + interval '1 month 04:01' AS "07:31:00";
 07:31:00 
----------
 07:31:00
(1 row)

SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01";
ERROR:  cannot cast type time with time zone to interval
SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08";
ERROR:  cannot cast type interval to time with time zone
SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08";
 23:29:00-08 
-------------
 23:29:00-08
(1 row)

SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08";
 14:31:00-08 
-------------
 14:31:00-08
(1 row)

-- These two tests cannot be used because they default to current timezone,
-- which may be either -08 or -07 depending on the time of year.
-- SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08";
-- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08";
-- Try the following two tests instead, as a poor substitute
SELECT CAST(CAST(date 'today' + time with time zone '05:30'
            + interval '02:01' AS time with time zone) AS time) AS "07:31:00";
 07:31:00 
----------
 07:31:00
(1 row)

SELECT CAST(cast(date 'today' + time with time zone '03:30'
  + interval '1 month 04:01' as timestamp without time zone) AS time) AS "07:31:00";
 07:31:00 
----------
 07:31:00
(1 row)

SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
  WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
    AND i.f1 BETWEEN '00:00' AND '23:00';
             102             
-----------------------------
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:02 1997
 Mon Feb 10 22:32:02 1997
 Mon Feb 10 17:33:01.40 1997
 Mon Feb 10 22:32:01.40 1997
 Mon Feb 10 17:33:01.50 1997
 Mon Feb 10 22:32:01.50 1997
 Mon Feb 10 17:33:01.60 1997
 Mon Feb 10 22:32:01.60 1997
 Thu Jan 02 00:01:00 1997
 Thu Jan 02 05:00:00 1997
 Thu Jan 02 03:05:05 1997
 Thu Jan 02 08:04:05 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Tue Jun 10 17:33:01 1997
 Tue Jun 10 22:32:01 1997
 Wed Mar 15 08:15:01 2000
 Wed Mar 15 13:14:01 2000
 Wed Mar 15 13:15:02 2000
 Wed Mar 15 18:14:02 2000
 Wed Mar 15 12:15:03 2000
 Wed Mar 15 17:14:03 2000
 Wed Mar 15 03:15:04 2000
 Wed Mar 15 08:14:04 2000
 Wed Mar 15 02:15:05 2000
 Wed Mar 15 07:14:05 2000
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:00 1997
 Mon Feb 10 22:32:00 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Tue Jun 10 18:33:01 1997
 Tue Jun 10 23:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Tue Feb 11 17:33:01 1997
 Tue Feb 11 22:32:01 1997
 Wed Feb 12 17:33:01 1997
 Wed Feb 12 22:32:01 1997
 Thu Feb 13 17:33:01 1997
 Thu Feb 13 22:32:01 1997
 Fri Feb 14 17:33:01 1997
 Fri Feb 14 22:32:01 1997
 Sat Feb 15 17:33:01 1997
 Sat Feb 15 22:32:01 1997
 Sun Feb 16 17:33:01 1997
 Sun Feb 16 22:32:01 1997
 Sun Feb 16 17:33:01 1997
 Sun Feb 16 22:32:01 1997
 Wed Feb 28 17:33:01 1996
 Wed Feb 28 22:32:01 1996
 Thu Feb 29 17:33:01 1996
 Thu Feb 29 22:32:01 1996
 Fri Mar 01 17:33:01 1996
 Fri Mar 01 22:32:01 1996
 Mon Dec 30 17:33:01 1996
 Mon Dec 30 22:32:01 1996
 Tue Dec 31 17:33:01 1996
 Tue Dec 31 22:32:01 1996
 Wed Jan 01 17:33:01 1997
 Wed Jan 01 22:32:01 1997
 Fri Feb 28 17:33:01 1997
 Fri Feb 28 22:32:01 1997
 Sat Mar 01 17:33:01 1997
 Sat Mar 01 22:32:01 1997
 Tue Dec 30 17:33:01 1997
 Tue Dec 30 22:32:01 1997
 Wed Dec 31 17:33:01 1997
 Wed Dec 31 22:32:01 1997
 Fri Dec 31 17:33:01 1999
 Fri Dec 31 22:32:01 1999
 Sat Jan 01 17:33:01 2000
 Sat Jan 01 22:32:01 2000
 Sun Dec 31 17:33:01 2000
 Sun Dec 31 22:32:01 2000
(102 rows)

SELECT t.d1 - i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
  WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
    AND i.f1 BETWEEN '00:00' AND '23:00';
             102             
-----------------------------
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:02 1997
 Mon Feb 10 12:32:02 1997
 Mon Feb 10 17:31:01.40 1997
 Mon Feb 10 12:32:01.40 1997
 Mon Feb 10 17:31:01.50 1997
 Mon Feb 10 12:32:01.50 1997
 Mon Feb 10 17:31:01.60 1997
 Mon Feb 10 12:32:01.60 1997
 Wed Jan 01 23:59:00 1997
 Wed Jan 01 19:00:00 1997
 Thu Jan 02 03:03:05 1997
 Wed Jan 01 22:04:05 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Tue Jun 10 17:31:01 1997
 Tue Jun 10 12:32:01 1997
 Wed Mar 15 08:13:01 2000
 Wed Mar 15 03:14:01 2000
 Wed Mar 15 13:13:02 2000
 Wed Mar 15 08:14:02 2000
 Wed Mar 15 12:13:03 2000
 Wed Mar 15 07:14:03 2000
 Wed Mar 15 03:13:04 2000
 Tue Mar 14 22:14:04 2000
 Wed Mar 15 02:13:05 2000
 Tue Mar 14 21:14:05 2000
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:00 1997
 Mon Feb 10 12:32:00 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Tue Jun 10 18:31:01 1997
 Tue Jun 10 13:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Tue Feb 11 17:31:01 1997
 Tue Feb 11 12:32:01 1997
 Wed Feb 12 17:31:01 1997
 Wed Feb 12 12:32:01 1997
 Thu Feb 13 17:31:01 1997
 Thu Feb 13 12:32:01 1997
 Fri Feb 14 17:31:01 1997
 Fri Feb 14 12:32:01 1997
 Sat Feb 15 17:31:01 1997
 Sat Feb 15 12:32:01 1997
 Sun Feb 16 17:31:01 1997
 Sun Feb 16 12:32:01 1997
 Sun Feb 16 17:31:01 1997
 Sun Feb 16 12:32:01 1997
 Wed Feb 28 17:31:01 1996
 Wed Feb 28 12:32:01 1996
 Thu Feb 29 17:31:01 1996
 Thu Feb 29 12:32:01 1996
 Fri Mar 01 17:31:01 1996
 Fri Mar 01 12:32:01 1996
 Mon Dec 30 17:31:01 1996
 Mon Dec 30 12:32:01 1996
 Tue Dec 31 17:31:01 1996
 Tue Dec 31 12:32:01 1996
 Wed Jan 01 17:31:01 1997
 Wed Jan 01 12:32:01 1997
 Fri Feb 28 17:31:01 1997
 Fri Feb 28 12:32:01 1997
 Sat Mar 01 17:31:01 1997
 Sat Mar 01 12:32:01 1997
 Tue Dec 30 17:31:01 1997
 Tue Dec 30 12:32:01 1997
 Wed Dec 31 17:31:01 1997
 Wed Dec 31 12:32:01 1997
 Fri Dec 31 17:31:01 1999
 Fri Dec 31 12:32:01 1999
 Sat Jan 01 17:31:01 2000
 Sat Jan 01 12:32:01 2000
 Sun Dec 31 17:31:01 2000
 Sun Dec 31 12:32:01 2000
(102 rows)

SELECT t.f1 + i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
     80      
-------------
 00:01:00
 05:00:00
 00:00:00
 00:00:00
 00:00:00
 23:59:46
 02:03:04
 00:00:00
 00:00:00
 12:00:00
 01:01:00
 06:00:00
 01:00:00
 01:00:00
 01:00:00
 00:59:46
 03:03:04
 01:00:00
 01:00:00
 13:00:00
 02:04:00
 07:03:00
 02:03:00
 02:03:00
 02:03:00
 02:02:46
 04:06:04
 02:03:00
 02:03:00
 14:03:00
 12:00:00
 16:59:00
 11:59:00
 11:59:00
 11:59:00
 11:58:46
 14:02:04
 11:59:00