datetime.out

关系型数据库 Postgresql 6.5.2

QUERY: SELECT ('today'::datetime = ('yesterday'::datetime + '1 day'::timespan)) as "True";
True
----
t   
(1 row)

QUERY: SELECT ('today'::datetime = ('tomorrow'::datetime - '1 day'::timespan)) as "True";
True
----
t   
(1 row)

QUERY: SELECT ('tomorrow'::datetime = ('yesterday'::datetime + '2 days'::timespan)) as "True";
True
----
t   
(1 row)

QUERY: SELECT ('current'::datetime = 'now'::datetime) as "True";
True
----
t   
(1 row)

QUERY: SELECT ('now'::datetime - 'current'::datetime) AS "ZeroSecs";
ZeroSecs
--------
@ 0     
(1 row)

QUERY: SET DateStyle = 'Postgres,noneuropean';
QUERY: SELECT datetime('1994-01-01', '11:00') AS "Jan_01_1994_11am";
Jan_01_1994_11am            
----------------------------
Sat Jan 01 11:00:00 1994 PST
(1 row)

QUERY: CREATE TABLE DATETIME_TBL( d1 datetime);
QUERY: INSERT INTO DATETIME_TBL VALUES ('current');
QUERY: INSERT INTO DATETIME_TBL VALUES ('today');
QUERY: INSERT INTO DATETIME_TBL VALUES ('yesterday');
QUERY: INSERT INTO DATETIME_TBL VALUES ('tomorrow');
QUERY: INSERT INTO DATETIME_TBL VALUES ('tomorrow EST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('tomorrow zulu');
QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'today'::datetime;
one
---
  1
(1 row)

QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'tomorrow'::datetime;
one
---
  1
(1 row)

QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'yesterday'::datetime;
one
---
  1
(1 row)

QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'today'::datetime + '1 day'::timespan;
one
---
  1
(1 row)

QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'today'::datetime - '1 day'::timespan;
one
---
  1
(1 row)

QUERY: SELECT count(*) AS one FROM DATETIME_TBL WHERE d1 = 'now'::datetime;
one
---
  1
(1 row)

QUERY: DELETE FROM DATETIME_TBL;
QUERY: INSERT INTO DATETIME_TBL VALUES ('current');
QUERY: BEGIN;
QUERY: INSERT INTO DATETIME_TBL VALUES ('now');
QUERY: SELECT count(*) AS two FROM DATETIME_TBL WHERE d1 = 'now'::datetime;
two
---
  2
(1 row)

QUERY: END;
QUERY: DELETE FROM DATETIME_TBL;
QUERY: INSERT INTO DATETIME_TBL VALUES ('invalid');
QUERY: INSERT INTO DATETIME_TBL VALUES ('-infinity');
QUERY: INSERT INTO DATETIME_TBL VALUES ('infinity');
QUERY: INSERT INTO DATETIME_TBL VALUES ('epoch');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mon Feb 10 17:32:01 1997 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Invalid Abstime');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Undefined Abstime');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mon Feb 10 17:32:01.000001 1997 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mon Feb 10 17:32:01.999999 1997 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mon Feb 10 17:32:01.4 1997 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mon Feb 10 17:32:01.5 1997 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mon Feb 10 17:32:01.6 1997 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-01-02');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-01-02 03:04:05');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-02-10 17:32:01-08');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-02-10 17:32:01-0800');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-02-10 17:32:01 -08:00');
QUERY: INSERT INTO DATETIME_TBL VALUES ('19970210 173201 -0800');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-06-10 17:32:01 -07:00');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 10 17:32:01 1997 -0800');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 10 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 10 5:32PM 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997/02/10 17:32:01-0800');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-02-10 17:32:01 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb-10-1997 17:32:01 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('02-10-1997 17:32:01 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('19970210 173201 PST');
QUERY: INSERT INTO DATETIME_TBL VALUES ('97FEB10 5:32:01PM UTC');
QUERY: INSERT INTO DATETIME_TBL VALUES ('97/02/10 17:32:01 UTC');
QUERY: INSERT INTO DATETIME_TBL VALUES ('97.041 17:32:01 UTC');
QUERY: INSERT INTO DATETIME_TBL VALUES ('1997-06-10 18:32:01 PDT');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 10 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 11 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 12 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 13 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 14 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 15 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 0097 BC');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 0097');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 0597');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 1097');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 1697');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 1797');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 1897');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 2097');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 28 17:32:01 1996');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 29 17:32:01 1996');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mar 01 17:32:01 1996');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Dec 30 17:32:01 1996');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Dec 31 17:32:01 1996');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Jan 01 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 28 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 29 17:32:01 1997');
ERROR:  Bad datetime external representation 'Feb 29 17:32:01 1997'
QUERY: INSERT INTO DATETIME_TBL VALUES ('Mar 01 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Dec 30 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Dec 31 17:32:01 1997');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Dec 31 17:32:01 1999');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Jan 01 17:32:01 2000');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Dec 31 17:32:01 2000');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Jan 01 17:32:01 2001');
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 -0097');
ERROR:  Bad datetime external representation 'Feb 16 17:32:01 -0097'
QUERY: INSERT INTO DATETIME_TBL VALUES ('Feb 16 17:32:01 5097 BC');
ERROR:  Datetime out of range 'Feb 16 17:32:01 5097 BC'
QUERY: SELECT '' AS sixtythree, d1 FROM DATETIME_TBL;
sixtythree|d1                             
----------+-------------------------------
          |invalid                        
          |-infinity                      
          |infinity                       
          |epoch                          
          |Mon Feb 10 17:32:01 1997 PST   
          |invalid                        
          |invalid                        
          |Mon Feb 10 17:32:01.00 1997 PST
          |Mon Feb 10 17:32:02.00 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   
          |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   
          |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 0097 BC       
          |Sat Feb 16 17:32:01 0097       
          |Thu Feb 16 17:32:01 0597       
          |Tue Feb 16 17:32:01 1097       
          |Sat Feb 16 17:32:01 1697       
          |Thu Feb 16 17:32:01 1797       
          |Tue Feb 16 17:32:01 1897       
          |Sun Feb 16 17:32:01 1997 PST   
          |Sat Feb 16 17:32:01 2097       
          |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   
(61 rows)

QUERY: SELECT '' AS fortythree, d1 FROM DATETIME_TBL
   WHERE d1 > '1997-01-02'::datetime and d1 != 'current'::datetime;
fortythree|d1                             
----------+-------------------------------
          |infinity                       
          |Mon Feb 10 17:32:01 1997 PST   
          |Mon Feb 10 17:32:01.00 1997 PST
          |Mon Feb 10 17:32:02.00 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   
          |Mon Feb 10 17:32:01 1997 PST   
          |Mon Feb 10 17:32:01 1997 PST   
          |Mon Feb 10 17:32:00 1997 PST