horology.out

关系型数据库 Postgresql 6.5.2

QUERY: SELECT '' AS ten, d.f1 AS datetime, '1980-01-06 00:00 GMT'::datetime AS gpstime_zero,
   d.f1 - '1980-01-06 00:00 GMT'::datetime AS difference
  FROM TEMP_DATETIME d
  ORDER BY difference;
ten|datetime                    |gpstime_zero                |difference                      
---+----------------------------+----------------------------+--------------------------------
   |epoch                       |Sat Jan 05 16:00:00 1980 PST|@ 3657 days ago                 
   |Wed Feb 28 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 5898 days 1 hour 32 mins 1 sec
   |Thu Feb 29 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 5899 days 1 hour 32 mins 1 sec
   |Fri Mar 01 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 5900 days 1 hour 32 mins 1 sec
   |Mon Dec 30 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 6204 days 1 hour 32 mins 1 sec
   |Tue Dec 31 17:32:01 1996 PST|Sat Jan 05 16:00:00 1980 PST|@ 6205 days 1 hour 32 mins 1 sec
   |Fri Dec 31 17:32:01 1999 PST|Sat Jan 05 16:00:00 1980 PST|@ 7300 days 1 hour 32 mins 1 sec
   |Sat Jan 01 17:32:01 2000 PST|Sat Jan 05 16:00:00 1980 PST|@ 7301 days 1 hour 32 mins 1 sec
   |Sun Dec 31 17:32:01 2000 PST|Sat Jan 05 16:00:00 1980 PST|@ 7666 days 1 hour 32 mins 1 sec
   |Mon Jan 01 17:32:01 2001 PST|Sat Jan 05 16:00:00 1980 PST|@ 7667 days 1 hour 32 mins 1 sec
(10 rows)

QUERY: SELECT '' AS hundred, d1.f1 AS datetime1, d2.f1 AS datetime2, d1.f1 - d2.f1 AS difference
  FROM TEMP_DATETIME d1, TEMP_DATETIME d2
  ORDER BY datetime1, datetime2, difference;
hundred|datetime1                   |datetime2                   |difference                           
-------+----------------------------+----------------------------+-------------------------------------
       |epoch                       |epoch                       |@ 0                                  
       |epoch                       |Wed Feb 28 17:32:01 1996 PST|@ 9555 days 1 hour 32 mins 1 sec ago 
       |epoch                       |Thu Feb 29 17:32:01 1996 PST|@ 9556 days 1 hour 32 mins 1 sec ago 
       |epoch                       |Fri Mar 01 17:32:01 1996 PST|@ 9557 days 1 hour 32 mins 1 sec ago 
       |epoch                       |Mon Dec 30 17:32:01 1996 PST|@ 9861 days 1 hour 32 mins 1 sec ago 
       |epoch                       |Tue Dec 31 17:32:01 1996 PST|@ 9862 days 1 hour 32 mins 1 sec ago 
       |epoch                       |Fri Dec 31 17:32:01 1999 PST|@ 10957 days 1 hour 32 mins 1 sec ago
       |epoch                       |Sat Jan 01 17:32:01 2000 PST|@ 10958 days 1 hour 32 mins 1 sec ago
       |epoch                       |Sun Dec 31 17:32:01 2000 PST|@ 11323 days 1 hour 32 mins 1 sec ago
       |epoch                       |Mon Jan 01 17:32:01 2001 PST|@ 11324 days 1 hour 32 mins 1 sec ago
       |Wed Feb 28 17:32:01 1996 PST|epoch                       |@ 9555 days 1 hour 32 mins 1 sec     
       |Wed Feb 28 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST|@ 0                                  
       |Wed Feb 28 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST|@ 1 day ago                          
       |Wed Feb 28 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 2 days ago                         
       |Wed Feb 28 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 306 days ago                       
       |Wed Feb 28 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 307 days ago                       
       |Wed Feb 28 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1402 days ago                      
       |Wed Feb 28 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1403 days ago                      
       |Wed Feb 28 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1768 days ago                      
       |Wed Feb 28 17:32:01 1996 PST|Mon Jan 01 17:32:01 2001 PST|@ 1769 days ago                      
       |Thu Feb 29 17:32:01 1996 PST|epoch                       |@ 9556 days 1 hour 32 mins 1 sec     
       |Thu Feb 29 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST|@ 1 day                              
       |Thu Feb 29 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST|@ 0                                  
       |Thu Feb 29 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 1 day ago                          
       |Thu Feb 29 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 305 days ago                       
       |Thu Feb 29 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 306 days ago                       
       |Thu Feb 29 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1401 days ago                      
       |Thu Feb 29 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1402 days ago                      
       |Thu Feb 29 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1767 days ago                      
       |Thu Feb 29 17:32:01 1996 PST|Mon Jan 01 17:32:01 2001 PST|@ 1768 days ago                      
       |Fri Mar 01 17:32:01 1996 PST|epoch                       |@ 9557 days 1 hour 32 mins 1 sec     
       |Fri Mar 01 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST|@ 2 days                             
       |Fri Mar 01 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST|@ 1 day                              
       |Fri Mar 01 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 0                                  
       |Fri Mar 01 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 304 days ago                       
       |Fri Mar 01 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 305 days ago                       
       |Fri Mar 01 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1400 days ago                      
       |Fri Mar 01 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1401 days ago                      
       |Fri Mar 01 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1766 days ago                      
       |Fri Mar 01 17:32:01 1996 PST|Mon Jan 01 17:32:01 2001 PST|@ 1767 days ago                      
       |Mon Dec 30 17:32:01 1996 PST|epoch                       |@ 9861 days 1 hour 32 mins 1 sec     
       |Mon Dec 30 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST|@ 306 days                           
       |Mon Dec 30 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST|@ 305 days                           
       |Mon Dec 30 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 304 days                           
       |Mon Dec 30 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 0                                  
       |Mon Dec 30 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 1 day ago                          
       |Mon Dec 30 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1096 days ago                      
       |Mon Dec 30 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1097 days ago                      
       |Mon Dec 30 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1462 days ago                      
       |Mon Dec 30 17:32:01 1996 PST|Mon Jan 01 17:32:01 2001 PST|@ 1463 days ago                      
       |Tue Dec 31 17:32:01 1996 PST|epoch                       |@ 9862 days 1 hour 32 mins 1 sec     
       |Tue Dec 31 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST|@ 307 days                           
       |Tue Dec 31 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST|@ 306 days                           
       |Tue Dec 31 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST|@ 305 days                           
       |Tue Dec 31 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST|@ 1 day                              
       |Tue Dec 31 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST|@ 0                                  
       |Tue Dec 31 17:32:01 1996 PST|Fri Dec 31 17:32:01 1999 PST|@ 1095 days ago                      
       |Tue Dec 31 17:32:01 1996 PST|Sat Jan 01 17:32:01 2000 PST|@ 1096 days ago                      
       |Tue Dec 31 17:32:01 1996 PST|Sun Dec 31 17:32:01 2000 PST|@ 1461 days ago                      
       |Tue Dec 31 17:32:01 1996 PST|Mon Jan 01 17:32:01 2001 PST|@ 1462 days ago                      
       |Fri Dec 31 17:32:01 1999 PST|epoch                       |@ 10957 days 1 hour 32 mins 1 sec    
       |Fri Dec 31 17:32:01 1999 PST|Wed Feb 28 17:32:01 1996 PST|@ 1402 days                          
       |Fri Dec 31 17:32:01 1999 PST|Thu Feb 29 17:32:01 1996 PST|@ 1401 days                          
       |Fri Dec 31 17:32:01 1999 PST|Fri Mar 01 17:32:01 1996 PST|@ 1400 days                          
       |Fri Dec 31 17:32:01 1999 PST|Mon Dec 30 17:32:01 1996 PST|@ 1096 days                          
       |Fri Dec 31 17:32:01 1999 PST|Tue Dec 31 17:32:01 1996 PST|@ 1095 days                          
       |Fri Dec 31 17:32:01 1999 PST|Fri Dec 31 17:32:01 1999 PST|@ 0                                  
       |Fri Dec 31 17:32:01 1999 PST|Sat Jan 01 17:32:01 2000 PST|@ 1 day ago                          
       |Fri Dec 31 17:32:01 1999 PST|Sun Dec 31 17:32:01 2000 PST|@ 366 days ago                       
       |Fri Dec 31 17:32:01 1999 PST|Mon Jan 01 17:32:01 2001 PST|@ 367 days ago                       
       |Sat Jan 01 17:32:01 2000 PST|epoch                       |@ 10958 days 1 hour 32 mins 1 sec    
       |Sat Jan 01 17:32:01 2000 PST|Wed Feb 28 17:32:01 1996 PST|@ 1403 days                          
       |Sat Jan 01 17:32:01 2000 PST|Thu Feb 29 17:32:01 1996 PST|@ 1402 days                          
       |Sat Jan 01 17:32:01 2000 PST|Fri Mar 01 17:32:01 1996 PST|@ 1401 days                          
       |Sat Jan 01 17:32:01 2000 PST|Mon Dec 30 17:32:01 1996 PST|@ 1097 days                          
       |Sat Jan 01 17:32:01 2000 PST|Tue Dec 31 17:32:01 1996 PST|@ 1096 days                          
       |Sat Jan 01 17:32:01 2000 PST|Fri Dec 31 17:32:01 1999 PST|@ 1 day                              
       |Sat Jan 01 17:32:01 2000 PST|Sat Jan 01 17:32:01 2000 PST|@ 0                                  
       |Sat Jan 01 17:32:01 2000 PST|Sun Dec 31 17:32:01 2000 PST|@ 365 days ago                       
       |Sat Jan 01 17:32:01 2000 PST|Mon Jan 01 17:32:01 2001 PST|@ 366 days ago                       
       |Sun Dec 31 17:32:01 2000 PST|epoch                       |@ 11323 days 1 hour 32 mins 1 sec    
       |Sun Dec 31 17:32:01 2000 PST|Wed Feb 28 17:32:01 1996 PST|@ 1768 days                          
       |Sun Dec 31 17:32:01 2000 PST|Thu Feb 29 17:32:01 1996 PST|@ 1767 days                          
       |Sun Dec 31 17:32:01 2000 PST|Fri Mar 01 17:32:01 1996 PST|@ 1766 days                          
       |Sun Dec 31 17:32:01 2000 PST|Mon Dec 30 17:32:01 1996 PST|@ 1462 days                          
       |Sun Dec 31 17:32:01 2000 PST|Tue Dec 31 17:32:01 1996 PST|@ 1461 days                          
       |Sun Dec 31 17:32:01 2000 PST|Fri Dec 31 17:32:01 1999 PST|@ 366 days                           
       |Sun Dec 31 17:32:01 2000 PST|Sat Jan 01 17:32:01 2000 PST|@ 365 days                           
       |Sun Dec 31 17:32:01 2000 PST|Sun Dec 31 17:32:01 2000 PST|@ 0                                  
       |Sun Dec 31 17:32:01 2000 PST|Mon Jan 01 17:32:01 2001 PST|@ 1 day ago                          
       |Mon Jan 01 17:32:01 2001 PST|epoch                       |@ 11324 days 1 hour 32 mins 1 sec    
       |Mon Jan 01 17:32:01 2001 PST|Wed Feb 28 17:32:01 1996 PST|@ 1769 days                          
       |Mon Jan 01 17:32:01 2001 PST|Thu Feb 29 17:32:01 1996 PST|@ 1768 days                          
       |Mon Jan 01 17:32:01 2001 PST|Fri Mar 01 17:32:01 1996 PST|@ 1767 days                          
       |Mon Jan 01 17:32:01 2001 PST|Mon Dec 30 17:32:01 1996 PST|@ 1463 days                          
       |Mon Jan 01 17:32:01 2001 PST|Tue Dec 31 17:32:01 1996 PST|@ 1462 days                          
       |Mon Jan 01 17:32:01 2001 PST|Fri Dec 31 17:32:01 1999 PST|@ 367 days                           
       |Mon Jan 01 17:32:01 2001 PST|Sat Jan 01 17:32:01 2000 PST|@ 366 days                           
       |Mon Jan 01 17:32:01 2001 PST|Sun Dec 31 17:32:01 2000 PST|@ 1 day                              
       |Mon Jan 01 17:32:01 2001 PST|Mon Jan 01 17:32:01 2001 PST|@ 0                                  
(100 rows)

QUERY: SELECT '' as fifty, d1 as datetime,
  date_part('year', d1) AS year, date_part('month', d1) AS month,
  date_part('day',d1) AS day, date_part('hour', d1) AS hour,
  date_part('minute', d1) AS minute, date_part('second', d1) AS second
  FROM DATETIME_TBL
  WHERE isfinite(d1) and d1 >= '1-jan-1900 GMT'
  ORDER BY datetime;
fifty|datetime                       |year|month|day|hour|minute|  second
-----+-------------------------------+----+-----+---+----+------+--------
     |epoch                          |1969|   12| 31|  16|     0|       0
     |Wed Feb 28 17:32:01 1996 PST   |1996|    2| 28|  17|    32|       1
     |Thu Feb 29 17:32:01 1996 PST   |1996|    2| 29|  17|    32|       1
     |Fri Mar 01 17:32:01 1996 PST   |1996|    3|  1|  17|    32|       1
     |Mon Dec 30 17:32:01 1996 PST   |1996|   12| 30|  17|    32|       1
     |Tue Dec 31 17:32:01 1996 PST   |1996|   12| 31|  17|    32|       1
     |Wed Jan 01 17:32:01 1997 PST   |1997|    1|  1|  17|    32|       1
     |Thu Jan 02 00:00:00 1997 PST   |1997|    1|  2|   0|     0|       0
     |Thu Jan 02 03:04:05 1997 PST   |1997|    1|  2|   3|     4|       5
     |Mon Feb 10 09:32:01 1997 PST   |1997|    2| 10|   9|    32|       1
     |Mon Feb 10 09:32:01 1997 PST   |1997|    2| 10|   9|    32|       1
     |Mon Feb 10 09:32:01 1997 PST   |1997|    2| 10|   9|    32|       1
     |Mon Feb 10 17:32:00 1997 PST   |1997|    2| 10|  17|    32|       0
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01 1997 PST   |1997|    2| 10|  17|    32|       1
     |Mon Feb 10 17:32:01.00 1997 PST|1997|    2| 10|  17|    32|1.000001
     |Mon Feb 10 17:32:01.40 1997 PST|1997|    2| 10|  17|    32|     1.4
     |Mon Feb 10 17:32:01.50 1997 PST|1997|    2| 10|  17|    32|     1.5
     |Mon Feb 10 17:32:01.60 1997 PST|1997|    2| 10|  17|    32|     1.6
     |Mon Feb 10 17:32:02.00 1997 PST|1997|    2| 10|  17|    32|1.999999
     |Tue Feb 11 17:32:01 1997 PST   |1997|    2| 11|  17|    32|       1
     |Wed Feb 12 17:32:01 1997 PST   |1997|    2| 12|  17|    32|       1
     |Thu Feb 13 17:32:01 1997 PST   |1997|    2| 13|  17|    32|       1
     |Fri Feb 14 17:32:01 1997 PST   |1997|    2| 14|  17|    32|       1
     |Sat Feb 15 17:32:01 1997 PST   |1997|    2| 15|  17|    32|       1
     |Sun Feb 16 17:32:01 1997 PST   |1997|    2| 16|  17|    32|       1
     |Sun Feb 16 17:32:01 1997 PST   |1997|    2| 16|  17|    32|       1
     |Fri Feb 28 17:32:01 1997 PST   |1997|    2| 28|  17|    32|       1
     |Sat Mar 01 17:32:01 1997 PST   |1997|    3|  1|  17|    32|       1
     |Tue Jun 10 17:32:01 1997 PDT   |1997|    6| 10|  17|    32|       1
     |Tue Jun 10 18:32:01 1997 PDT   |1997|    6| 10|  18|    32|       1
     |Tue Dec 30 17:32:01 1997 PST   |1997|   12| 30|  17|    32|       1
     |Wed Dec 31 17:32:01 1997 PST   |1997|   12| 31|  17|    32|       1
     |Fri Dec 31 17:32:01 1999 PST   |1999|   12| 31|  17|    32|       1
     |Sat Jan 01 17:32:01 2000 PST   |2000|    1|  1|  17|    32|       1
     |Sun Dec 31 17:32:01 2000 PST   |2000|   12| 31|  17|    32|       1
     |Mon Jan 01 17:32:01 2001 PST   |2001|    1|  1|  17|    32|       1
     |Sat Feb 16 17:32:01 2097       |2097|    2| 16|  17|    32|       1
(49 rows)

QUERY: SELECT '' AS four, f1 AS abstime,
  date_part('year', f1) AS year, date_part('month', f1) AS month,
  date_part('day',f1) AS day, date_part('hour', f1) AS hour,
  date_part('minute', f1) AS minute, date_part('second', f1) AS second
  FROM ABSTIME_TBL
  WHERE isfinite(f1) and f1 <> 'current'::abstime
  ORDER BY abstime;
four|abstime                     |year|month|day|hour|minute|second
----+----------------------------+----+-----+---+----+------+------
    |Sat May 10 23:59:12 1947 PST|1947|    5| 10|  23|    59|    12
    |epoch                       |1969|   12| 31|  16|     0|     0
    |Sun Jan 14 03:14:21 1973 PST|1973|    1| 14|   3|    14|    21
    |Mon May 01 00:30:30 1995 PDT|1995|    5|  1|   0|    30|    30
(4 rows)

QUERY: SELECT '' AS ten, f1 AS datetime, date( f1) AS date
  FROM TEMP_DATETIME
  WHERE f1 <> 'current'::datetime
  ORDER BY date;
ten|datetime                    |      date
---+----------------------------+----------
   |epoch                       |01-01-1970
   |Wed Feb 28 17:32:01 1996 PST|02-28-1996
   |Thu Feb 29 17:32:01 1996 PST|02-29-1996
   |Fri Mar 01 17:32:01 1996 PST|03-01-1996
   |Mon Dec 30 17:32:01 1996 PST|12-30-1996
   |Tue Dec 31 17:32:01 1996 PST|12-31-1996
   |Fri Dec 31 17:32:01 1999 PST|12-31-1999
   |Sat Jan 01 17:32:01 2000 PST|01-01-2000
   |Sun Dec 31 17:32:01 2000 PST|12-31-2000
   |Mon Jan 01 17:32:01 2001 PST|01-01-2001
(10 rows)

QUERY: SELECT '' AS ten, f1 AS datetime, abstime( f1) AS abstime
  FROM TEMP_DATETIME
  ORDER BY abstime;
ten|datetime                    |abstime                     
---+----------------------------+----------------------------
   |epoch                       |epoch                       
   |Wed Feb 28 17:32:01 1996 PST|Wed Feb 28 17:32:01 1996 PST
   |Thu Feb 29 17:32:01 1996 PST|Thu Feb 29 17:32:01 1996 PST
   |Fri Mar 01 17:32:01 1996 PST|Fri Mar 01 17:32:01 1996 PST
   |Mon Dec 30 17:32:01 1996 PST|Mon Dec 30 17:32:01 1996 PST
   |Tue Dec 31 17:32:01 1996 PST|Tue Dec 31 17:32:01 1996 PST
   |Fri Dec 31 17:32:01 1999 PST|Fri Dec 31 17:32:01 1999 PST
   |Sat Jan 01 17:32:01 2000 PST|Sat Jan 01 17:32:01 2000 PST
   |Sun Dec 31 17:32:01 2000 PST|Sun Dec 31 17:32:01 2000 PST
   |Mon Jan 01 17:32:01 2001 PST|Mon Jan 01 17:32:01 2001 PST
(10 rows)