horology.out

关系型数据库 Postgresql 6.5.2

QUERY: SELECT '' AS five, f1 AS abstime, date( f1) AS date
  FROM ABSTIME_TBL
  WHERE isfinite(f1) AND f1 <> 'current'::abstime
  ORDER BY date;
five|abstime                     |      date
----+----------------------------+----------
    |Sat May 10 23:59:12 1947 PST|05-10-1947
    |epoch                       |01-01-1970
    |Sun Jan 14 03:14:21 1973 PST|01-14-1973
    |Mon May 01 00:30:30 1995 PDT|05-01-1995
(4 rows)

QUERY: SELECT '' AS five, d1 AS datetime, abstime(d1) AS abstime
  FROM DATETIME_TBL WHERE NOT isfinite(d1);
five|datetime |abstime  
----+---------+---------
    |invalid  |invalid  
    |-infinity|-infinity
    |infinity |infinity 
    |invalid  |invalid  
    |invalid  |invalid  
(5 rows)

QUERY: SELECT '' AS three, f1 as abstime, datetime(f1) AS datetime
  FROM ABSTIME_TBL WHERE NOT isfinite(f1);
three|abstime  |datetime 
-----+---------+---------
     |infinity |infinity 
     |-infinity|-infinity
     |invalid  |invalid  
(3 rows)

QUERY: SELECT '' AS ten, f1 AS timespan, reltime( f1) AS reltime
  FROM TIMESPAN_TBL;
ten|timespan                     |reltime                      
---+-----------------------------+-----------------------------
   |@ 1 min                      |@ 1 min                      
   |@ 5 hours                    |@ 5 hours                    
   |@ 10 days                    |@ 10 days                    
   |@ 34 years                   |@ 34 years                   
   |@ 3 mons                     |@ 3 mons                     
   |@ 14 secs ago                |@ 14 secs ago                
   |@ 1 day 2 hours 3 mins 4 secs|@ 1 day 2 hours 3 mins 4 secs
   |@ 6 years                    |@ 6 years                    
   |@ 5 mons                     |@ 5 mons                     
   |@ 5 mons 12 hours            |@ 5 mons 12 hours            
(10 rows)

QUERY: SELECT '' AS six, f1 as reltime, timespan( f1) AS timespan
  FROM RELTIME_TBL;
six|reltime      |timespan     
---+-------------+-------------
   |@ 1 min      |@ 1 min      
   |@ 5 hours    |@ 5 hours    
   |@ 10 days    |@ 10 days    
   |@ 34 years   |@ 34 years   
   |@ 3 mons     |@ 3 mons     
   |@ 14 secs ago|@ 14 secs ago
(6 rows)

QUERY: DROP TABLE TEMP_DATETIME;
QUERY: SET DateStyle TO 'US,Postgres';
QUERY: SHOW DateStyle;
NOTICE:  DateStyle is Postgres with US (NonEuropean) conventions
QUERY: SELECT '' AS sixty_two, d1 AS us_postgres FROM DATETIME_TBL;
sixty_two|us_postgres                    
---------+-------------------------------
         |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 eight, f1 AS us_postgres FROM ABSTIME_TBL;
eight|us_postgres                 
-----+----------------------------
     |Sun Jan 14 03:14:21 1973 PST
     |Mon May 01 00:30:30 1995 PDT
     |epoch                       
     |current                     
     |infinity                    
     |-infinity                   
     |Sat May 10 23:59:12 1947 PST
     |invalid                     
(8 rows)

QUERY: SET DateStyle TO 'US,ISO';
QUERY: SELECT '' AS sixty_two, d1 AS us_iso FROM DATETIME_TBL;
sixty_two|us_iso                   
---------+-------------------------
         |invalid                  
         |-infinity                
         |infinity                 
         |epoch                    
         |1997-02-10 17:32:01-08   
         |invalid                  
         |invalid                  
         |1997-02-10 17:32:01.00-08
         |1997-02-10 17:32:02.00-08
         |1997-02-10 17:32:01.40-08
         |1997-02-10 17:32:01.50-08
         |1997-02-10 17:32:01.60-08
         |1997-01-02 00:00:00-08   
         |1997-01-02 03:04:05-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-06-10 17:32:01-07   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:00-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 17:32:01-08   
         |1997-02-10 09:32:01-08   
         |1997-02-10 09:32:01-08   
         |1997-02-10 09:32:01-08   
         |1997-06-10 18:32:01-07   
         |1997-02-10 17:32:01-08   
         |1997-02-11 17:32:01-08   
         |1997-02-12 17:32:01-08   
         |1997-02-13 17:32:01-08   
         |1997-02-14 17:32:01-08   
         |1997-02-15 17:32:01-08   
         |1997-02-16 17:32:01-08   
         |0097-02-16 17:32 BC      
         |0097-02-16 17:32:01      
         |0597-02-16 17:32:01      
         |1097-02-16 17:32:01      
         |1697-02-16 17:32:01      
         |1797-02-16 17:32:01      
         |1897-02-16 17:32:01      
         |1997-02-16 17:32:01-08   
         |2097-02-16 17:32:01      
         |1996-02-28 17:32:01-08   
         |1996-02-29 17:32:01-08   
         |1996-03-01 17:32:01-08   
         |1996-12-30 17:32:01-08   
         |1996-12-31 17:32:01-08   
         |1997-01-01 17:32:01-08   
         |1997-02-28 17:32:01-08   
         |1997-03-01 17:32:01-08   
         |1997-12-30 17:32:01-08   
         |1997-12-31 17:32:01-08   
         |1999-12-31 17:32:01-08   
         |2000-01-01 17:32:01-08   
         |2000-12-31 17:32:01-08   
         |2001-01-01 17:32:01-08   
(61 rows)

QUERY: SELECT '' AS eight, f1 AS us_iso FROM ABSTIME_TBL;
eight|us_iso                
-----+----------------------
     |1973-01-14 03:14:21-08
     |1995-05-01 00:30:30-07
     |epoch                 
     |current               
     |infinity              
     |-infinity             
     |1947-05-10 23:59:12-08
     |invalid               
(8 rows)

QUERY: SET DateStyle TO 'US,SQL';
QUERY: SHOW DateStyle;
NOTICE:  DateStyle is SQL with US (NonEuropean) conventions
QUERY: SELECT '' AS sixty_two, d1 AS us_sql FROM DATETIME_TBL;
sixty_two|us_sql                    
---------+--------------------------
         |invalid                   
         |-infinity                 
         |infinity                  
         |epoch                     
         |02/10/1997 17:32:01.00 PST
         |invalid                   
         |invalid