horology.out

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

 True 
------
 t
(1 row)

SELECT (timestamp without time zone 'tomorrow' > 'now') as "True";
 True 
------
 t
(1 row)

-- Convert from date and time to timestamp
-- This test used to be timestamp(date,time) but no longer allowed by grammar
-- to enable support for SQL99 timestamp type syntax.
SELECT date '1994-01-01' + time '11:00' AS "Jan_01_1994_11am";
     Jan_01_1994_11am     
--------------------------
 Sat Jan 01 11:00:00 1994
(1 row)

SELECT date '1994-01-01' + time '10:00' AS "Jan_01_1994_10am";
     Jan_01_1994_10am     
--------------------------
 Sat Jan 01 10:00:00 1994
(1 row)

SELECT date '1994-01-01' + timetz '11:00-5' AS "Jan_01_1994_8am";
       Jan_01_1994_8am        
------------------------------
 Sat Jan 01 08:00:00 1994 PST
(1 row)

SELECT timestamptz(date '1994-01-01', time with time zone '11:00-5') AS "Jan_01_1994_8am";
       Jan_01_1994_8am        
------------------------------
 Sat Jan 01 08:00:00 1994 PST
(1 row)

SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMP_TBL;
 64 |          one_year           
----+-----------------------------
    | -infinity
    | infinity
    | Fri Jan 01 00:00:00 1971
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:02 1998
    | Tue Feb 10 17:32:01.40 1998
    | Tue Feb 10 17:32:01.50 1998
    | Tue Feb 10 17:32:01.60 1998
    | Fri Jan 02 00:00:00 1998
    | Fri Jan 02 03:04:05 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Wed Jun 10 17:32:01 1998
    | Sun Sep 22 18:19:20 2002
    | Thu Mar 15 08:14:01 2001
    | Thu Mar 15 13:14:02 2001
    | Thu Mar 15 12:14:03 2001
    | Thu Mar 15 03:14:04 2001
    | Thu Mar 15 02:14:05 2001
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:00 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Wed Jun 10 18:32:01 1998
    | Tue Feb 10 17:32:01 1998
    | Wed Feb 11 17:32:01 1998
    | Thu Feb 12 17:32:01 1998
    | Fri Feb 13 17:32:01 1998
    | Sat Feb 14 17:32:01 1998
    | Sun Feb 15 17:32:01 1998
    | Mon Feb 16 17:32:01 1998
    | Thu Feb 16 17:32:01 0096 BC
    | Sun Feb 16 17:32:01 0098
    | Fri Feb 16 17:32:01 0598
    | Wed Feb 16 17:32:01 1098
    | Sun Feb 16 17:32:01 1698
    | Fri Feb 16 17:32:01 1798
    | Wed Feb 16 17:32:01 1898
    | Mon Feb 16 17:32:01 1998
    | Sun Feb 16 17:32:01 2098
    | Fri Feb 28 17:32:01 1997
    | Fri Feb 28 17:32:01 1997
    | Sat Mar 01 17:32:01 1997
    | Tue Dec 30 17:32:01 1997
    | Wed Dec 31 17:32:01 1997
    | Thu Jan 01 17:32:01 1998
    | Sat Feb 28 17:32:01 1998
    | Sun Mar 01 17:32:01 1998
    | Wed Dec 30 17:32:01 1998
    | Thu Dec 31 17:32:01 1998
    | Sun Dec 31 17:32:01 2000
    | Mon Jan 01 17:32:01 2001
    | Mon Dec 31 17:32:01 2001
    | Tue Jan 01 17:32:01 2002
(64 rows)

SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMP_TBL;
 64 |          one_year           
----+-----------------------------
    | -infinity
    | infinity
    | Wed Jan 01 00:00:00 1969
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:02 1996
    | Sat Feb 10 17:32:01.40 1996
    | Sat Feb 10 17:32:01.50 1996
    | Sat Feb 10 17:32:01.60 1996
    | Tue Jan 02 00:00:00 1996
    | Tue Jan 02 03:04:05 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Mon Jun 10 17:32:01 1996
    | Fri Sep 22 18:19:20 2000
    | Mon Mar 15 08:14:01 1999
    | Mon Mar 15 13:14:02 1999
    | Mon Mar 15 12:14:03 1999
    | Mon Mar 15 03:14:04 1999
    | Mon Mar 15 02:14:05 1999
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:00 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Mon Jun 10 18:32:01 1996
    | Sat Feb 10 17:32:01 1996
    | Sun Feb 11 17:32:01 1996
    | Mon Feb 12 17:32:01 1996
    | Tue Feb 13 17:32:01 1996
    | Wed Feb 14 17:32:01 1996
    | Thu Feb 15 17:32:01 1996
    | Fri Feb 16 17:32:01 1996
    | Mon Feb 16 17:32:01 0098 BC
    | Thu Feb 16 17:32:01 0096
    | Tue Feb 16 17:32:01 0596
    | Sun Feb 16 17:32:01 1096
    | Thu Feb 16 17:32:01 1696
    | Tue Feb 16 17:32:01 1796
    | Sun Feb 16 17:32:01 1896
    | Fri Feb 16 17:32:01 1996
    | Thu Feb 16 17:32:01 2096
    | Tue Feb 28 17:32:01 1995
    | Tue Feb 28 17:32:01 1995
    | Wed Mar 01 17:32:01 1995
    | Sat Dec 30 17:32:01 1995
    | Sun Dec 31 17:32:01 1995
    | Mon Jan 01 17:32:01 1996
    | Wed Feb 28 17:32:01 1996
    | Fri Mar 01 17:32:01 1996
    | Mon Dec 30 17:32:01 1996
    | Tue Dec 31 17:32:01 1996
    | Thu Dec 31 17:32:01 1998
    | Fri Jan 01 17:32:01 1999
    | Fri Dec 31 17:32:01 1999
    | Sat Jan 01 17:32:01 2000
(64 rows)

SELECT timestamp with time zone '1996-03-01' - interval '1 second' AS "Feb 29";
            Feb 29            
------------------------------
 Thu Feb 29 23:59:59 1996 PST
(1 row)

SELECT timestamp with time zone '1999-03-01' - interval '1 second' AS "Feb 28";
            Feb 28            
------------------------------
 Sun Feb 28 23:59:59 1999 PST
(1 row)

SELECT timestamp with time zone '2000-03-01' - interval '1 second' AS "Feb 29";
            Feb 29            
------------------------------
 Tue Feb 29 23:59:59 2000 PST
(1 row)

SELECT timestamp with time zone '1999-12-01' + interval '1 month - 1 second' AS "Dec 31";
            Dec 31            
------------------------------
 Fri Dec 31 23:59:59 1999 PST
(1 row)

SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
 True 
------
 t
(1 row)

SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
 True 
------
 t
(1 row)

SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
 True 
------
 t
(1 row)

SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
 True 
------
 t
(1 row)

-- timestamp with time zone, interval arithmetic around DST change
SET TIME ZONE 'CST7CDT';
SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
         Apr 3, 12:00         
------------------------------
 Sun Apr 03 12:00:00 2005 CDT
(1 row)

SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
         Apr 3, 13:00         
------------------------------
 Sun Apr 03 13:00:00 2005 CDT
(1 row)

SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
         Apr 2, 12:00         
------------------------------
 Sat Apr 02 12:00:00 2005 CST
(1 row)

SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
         Apr 2, 11:00         
------------------------------
 Sat Apr 02 11:00:00 2005 CST
(1 row)

RESET TIME ZONE;
SELECT timestamptz(date '1994-01-01', time '11:00') AS "Jan_01_1994_10am";
       Jan_01_1994_10am       
------------------------------
 Sat Jan 01 11:00:00 1994 PST
(1 row)

SELECT timestamptz(date '1994-01-01', time '10:00') AS "Jan_01_1994_9am";
       Jan_01_1994_9am        
------------------------------
 Sat Jan 01 10:00:00 1994 PST
(1 row)

SELECT timestamptz(date '1994-01-01', time with time zone '11:00-8') AS "Jan_01_1994_11am";
       Jan_01_1994_11am       
------------------------------
 Sat Jan 01 11:00:00 1994 PST
(1 row)

SELECT timestamptz(date '1994-01-01', time with time zone '10:00-8') AS "Jan_01_1994_10am";
       Jan_01_1994_10am       
------------------------------
 Sat Jan 01 10:00:00 1994 PST
(1 row)

SELECT timestamptz(date '1994-01-01', time with time zone '11:00-5') AS "Jan_01_1994_8am";
       Jan_01_1994_8am        
------------------------------
 Sat Jan 01 08:00:00 1994 PST
(1 row)

SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
 64 |            one_year             
----+---------------------------------
    | -infinity
    | infinity
    | Thu Dec 31 16:00:00 1970 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:02 1998 PST
    | Tue Feb 10 17:32:01.40 1998 PST
    | Tue Feb 10 17:32:01.50 1998 PST
    | Tue Feb 10 17:32:01.60 1998 PST
    | Fri Jan 02 00:00:00 1998 PST
    | Fri Jan 02 03:04:05 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Wed Jun 10 17:32:01 1998 PDT
    | Sun Sep 22 18:19:20 2002 PDT
    | Thu Mar 15 08:14:01 2001 PST
    | Thu Mar 15 04:14:02 2001 PST
    | Thu Mar 15 02:14:03 2001 PST
    | Thu Mar 15 03:14:04 2001 PST
    | Thu Mar 15 01:14:05 2001 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:00 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 09:32:01 1998 PST
    | Tue Feb 10 09:32:01 1998 PST
    | Tue Feb 10 09:32:01 1998 PST
    | Wed Jun 10 18:32:01 1998 PDT
    | Tue Feb 10 17:32:01 1998 PST
    | Wed Feb 11 17:32:01 1998 PST
    | Thu Feb 12 17:32:01 1998 PST
    | Fri Feb 13 17:32:01 1998 PST
    | Sat Feb 14 17:32:01 1998 PST
    | Sun Feb 15 17:32:01 1998 PST
    | Mon Feb 16 17:32:01 1998 PST
    | Thu Feb 16 17:32:01 0096 PST BC
    | Sun Feb 16 17:32:01 0098 PST
    | Fri Feb 16 17:32:01 0598 PST
    | Wed Feb 16 17:32:01 1098 PST
    | Sun Feb 16 17:32:01 1698 PST
    | Fri Feb 16 17:32:01 1798 PST
    | Wed Feb 16 17:32:01 1898 PST
    | Mon Feb 16 17:32:01 1998 PST
    | Sun Feb 16 17:32:01 2098 PST
    | Fri Feb 28 17:32:01 1997 PST
    | Fri Feb 28 17:32:01 1997 PST
    | Sat Mar 01 17:32:01 1997 PST
    | Tue Dec 30 17:32:01 1997 PST
    | Wed Dec 31 17:32:01 1997 PST
    | Thu Jan 01 17:32:01 1998 PST
    | Sat Feb 28 17:32:01 1998 PST
    | Sun Mar 01 17:32:01 1998 PST
    | Wed Dec 30 17:32:01 1998 PST
    | Thu Dec 31 17:32:01 1998 PST
    | Sun Dec 31 17:32:01 2000 PST
    | Mon Jan 01 17:32:01 2001 PST
    | Mon Dec 31 17:32:01 2001 PST
    | Tue Jan 01 17:32:01 2002 PST
(64 rows)

SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
 64 |            one_year             
----+---------------------------------
    | -infinity
    | infinity
    | Tue Dec 31 16:00:00 1968 PST
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:02 1996 PST
    | Sat Feb 10 17:32:01.40 1996 PST
    | Sat Feb 10 17:32:01.50 1996 PST
    | Sat Feb 10 17:32:01.60 1996 PST
    | Tue Jan 02 00:00:00 1996 PST
    | Tue Jan 02 03:04:05 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
    | Mon Jun 10 17:32:01 1996 PDT
    | Fri Sep 22 18:19:20 2000 PDT
    | Mon Mar 15 08:14:01 1999 PST
    | Mon Mar 15 04:14:02 1999 PST
    | Mon Mar 15 02:14:03 1999 PST
    | Mon Mar 15 03:14:04 1999 PST
    | Mon Mar 15 01:14:05 1999 PST
    | Sat Feb 10 17:32:01 1996 PST