timestamptz.out

来自「postgresql8.3.4源码,开源数据库」· OUT 代码 · 共 1,335 行 · 第 1/5 页

    | Thu Feb 16 17:32:01 1797 PST
    | Tue Feb 16 17:32:01 1897 PST
    | Sun Feb 16 17:32:01 1997 PST
    | Sat Feb 16 17:32:01 2097 PST
    | Wed Feb 28 17:32:01 1996 PST
    | Thu Feb 29 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
    | Wed Jan 01 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
    | Fri Dec 31 17:32:01 1999 PST
    | Sat Jan 01 17:32:01 2000 PST
    | Sun Dec 31 17:32:01 2000 PST
    | Mon Jan 01 17:32:01 2001 PST
(66 rows)

-- Demonstrate functions and operators
SELECT '' AS "48", d1 FROM TIMESTAMPTZ_TBL
   WHERE d1 > timestamp with time zone '1997-01-02';
 48 |               d1                
----+---------------------------------
    | infinity
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:02 1997 PST
    | Mon Feb 10 17:32:01.40 1997 PST
    | Mon Feb 10 17:32:01.50 1997 PST
    | Mon Feb 10 17:32:01.60 1997 PST
    | Thu Jan 02 03:04:05 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Tue Jun 10 17:32:01 1997 PDT
    | Sat Sep 22 18:19:20 2001 PDT
    | Wed Mar 15 08:14:01 2000 PST
    | Wed Mar 15 04:14:02 2000 PST
    | Wed Mar 15 02:14:03 2000 PST
    | Wed Mar 15 03:14:04 2000 PST
    | Wed Mar 15 01:14:05 2000 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:00 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 14:32:01 1997 PST
    | Thu Jul 10 14:32:01 1997 PDT
    | Tue Jun 10 18:32:01 1997 PDT
    | Mon Feb 10 17:32:01 1997 PST
    | Tue Feb 11 17:32:01 1997 PST
    | Wed Feb 12 17:32:01 1997 PST
    | Thu Feb 13 17:32:01 1997 PST
    | Fri Feb 14 17:32:01 1997 PST
    | Sat Feb 15 17:32:01 1997 PST
    | Sun Feb 16 17:32:01 1997 PST
    | Sun Feb 16 17:32:01 1997 PST
    | Sat Feb 16 17:32:01 2097 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
    | Fri Dec 31 17:32:01 1999 PST
    | Sat Jan 01 17:32:01 2000 PST
    | Sun Dec 31 17:32:01 2000 PST
    | Mon Jan 01 17:32:01 2001 PST
(50 rows)

SELECT '' AS "15", d1 FROM TIMESTAMPTZ_TBL
   WHERE d1 < timestamp with time zone '1997-01-02';
 15 |               d1                
----+---------------------------------
    | -infinity
    | Wed Dec 31 16:00:00 1969 PST
    | Tue Feb 16 17:32:01 0097 PST BC
    | Sat Feb 16 17:32:01 0097 PST
    | Thu Feb 16 17:32:01 0597 PST
    | Tue Feb 16 17:32:01 1097 PST
    | Sat Feb 16 17:32:01 1697 PST
    | Thu Feb 16 17:32:01 1797 PST
    | Tue Feb 16 17:32:01 1897 PST
    | Wed Feb 28 17:32:01 1996 PST
    | Thu Feb 29 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
    | Wed Jan 01 17:32:01 1997 PST
(15 rows)

SELECT '' AS one, d1 FROM TIMESTAMPTZ_TBL
   WHERE d1 = timestamp with time zone '1997-01-02';
 one |              d1              
-----+------------------------------
     | Thu Jan 02 00:00:00 1997 PST
(1 row)

SELECT '' AS "63", d1 FROM TIMESTAMPTZ_TBL
   WHERE d1 != timestamp with time zone '1997-01-02';
 63 |               d1                
----+---------------------------------
    | -infinity
    | infinity
    | Wed Dec 31 16:00:00 1969 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:02 1997 PST
    | Mon Feb 10 17:32:01.40 1997 PST
    | Mon Feb 10 17:32:01.50 1997 PST
    | Mon Feb 10 17:32:01.60 1997 PST
    | Thu Jan 02 03:04:05 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Tue Jun 10 17:32:01 1997 PDT
    | Sat Sep 22 18:19:20 2001 PDT
    | Wed Mar 15 08:14:01 2000 PST
    | Wed Mar 15 04:14:02 2000 PST
    | Wed Mar 15 02:14:03 2000 PST
    | Wed Mar 15 03:14:04 2000 PST
    | Wed Mar 15 01:14:05 2000 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:00 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 14:32:01 1997 PST
    | Thu Jul 10 14:32:01 1997 PDT
    | Tue Jun 10 18:32:01 1997 PDT
    | Mon Feb 10 17:32:01 1997 PST
    | Tue Feb 11 17:32:01 1997 PST
    | Wed Feb 12 17:32:01 1997 PST
    | Thu Feb 13 17:32:01 1997 PST
    | Fri Feb 14 17:32:01 1997 PST
    | Sat Feb 15 17:32:01 1997 PST
    | Sun Feb 16 17:32:01 1997 PST
    | Tue Feb 16 17:32:01 0097 PST BC
    | Sat Feb 16 17:32:01 0097 PST
    | Thu Feb 16 17:32:01 0597 PST
    | Tue Feb 16 17:32:01 1097 PST
    | Sat Feb 16 17:32:01 1697 PST
    | Thu Feb 16 17:32:01 1797 PST
    | Tue Feb 16 17:32:01 1897 PST
    | Sun Feb 16 17:32:01 1997 PST
    | Sat Feb 16 17:32:01 2097 PST
    | Wed Feb 28 17:32:01 1996 PST
    | Thu Feb 29 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
    | Wed Jan 01 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
    | Fri Dec 31 17:32:01 1999 PST
    | Sat Jan 01 17:32:01 2000 PST
    | Sun Dec 31 17:32:01 2000 PST
    | Mon Jan 01 17:32:01 2001 PST
(65 rows)

SELECT '' AS "16", d1 FROM TIMESTAMPTZ_TBL
   WHERE d1 <= timestamp with time zone '1997-01-02';
 16 |               d1                
----+---------------------------------
    | -infinity
    | Wed Dec 31 16:00:00 1969 PST
    | Thu Jan 02 00:00:00 1997 PST
    | Tue Feb 16 17:32:01 0097 PST BC
    | Sat Feb 16 17:32:01 0097 PST
    | Thu Feb 16 17:32:01 0597 PST
    | Tue Feb 16 17:32:01 1097 PST
    | Sat Feb 16 17:32:01 1697 PST
    | Thu Feb 16 17:32:01 1797 PST
    | Tue Feb 16 17:32:01 1897 PST
    | Wed Feb 28 17:32:01 1996 PST
    | Thu Feb 29 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
    | Wed Jan 01 17:32:01 1997 PST
(16 rows)

SELECT '' AS "49", d1 FROM TIMESTAMPTZ_TBL
   WHERE d1 >= timestamp with time zone '1997-01-02';
 49 |               d1                
----+---------------------------------
    | infinity
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:02 1997 PST
    | Mon Feb 10 17:32:01.40 1997 PST
    | Mon Feb 10 17:32:01.50 1997 PST
    | Mon Feb 10 17:32:01.60 1997 PST
    | Thu Jan 02 00:00:00 1997 PST
    | Thu Jan 02 03:04:05 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Tue Jun 10 17:32:01 1997 PDT
    | Sat Sep 22 18:19:20 2001 PDT
    | Wed Mar 15 08:14:01 2000 PST
    | Wed Mar 15 04:14:02 2000 PST
    | Wed Mar 15 02:14:03 2000 PST
    | Wed Mar 15 03:14:04 2000 PST
    | Wed Mar 15 01:14:05 2000 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:00 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 17:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 09:32:01 1997 PST
    | Mon Feb 10 14:32:01 1997 PST
    | Thu Jul 10 14:32:01 1997 PDT
    | Tue Jun 10 18:32:01 1997 PDT
    | Mon Feb 10 17:32:01 1997 PST
    | Tue Feb 11 17:32:01 1997 PST
    | Wed Feb 12 17:32:01 1997 PST
    | Thu Feb 13 17:32:01 1997 PST
    | Fri Feb 14 17:32:01 1997 PST
    | Sat Feb 15 17:32:01 1997 PST
    | Sun Feb 16 17:32:01 1997 PST
    | Sun Feb 16 17:32:01 1997 PST
    | Sat Feb 16 17:32:01 2097 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
    | Fri Dec 31 17:32:01 1999 PST
    | Sat Jan 01 17:32:01 2000 PST
    | Sun Dec 31 17:32:01 2000 PST
    | Mon Jan 01 17:32:01 2001 PST
(51 rows)

SELECT '' AS "54", d1 - timestamp with time zone '1997-01-02' AS diff
   FROM TIMESTAMPTZ_TBL WHERE d1 BETWEEN '1902-01-01' AND '2038-01-01';
 54 |                  diff                  
----+----------------------------------------
    | @ 9863 days 8 hours ago
    | @ 39 days 17 hours 32 mins 1 sec
    | @ 39 days 17 hours 32 mins 1 sec
    | @ 39 days 17 hours 32 mins 2 secs
    | @ 39 days 17 hours 32 mins 1.40 secs
    | @ 39 days 17 hours 32 mins 1.50 secs
    | @ 39 days 17 hours 32 mins 1.60 secs
    | @ 0