horology-no-DST-before-1970.out 116 KB
Newer Older
1 2 3
--
-- HOROLOGY
--
4 5
-- needed so tests pass even in Australia
SET australian_timezones = 'off';
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243
SET DateStyle = 'Postgres,US';
--
-- Test various input formats
--
SELECT timestamp with time zone '20011227 040506+08';
         timestamptz          
------------------------------
 Wed Dec 26 12:05:06 2001 PST
(1 row)

SELECT timestamp with time zone '20011227 040506-08';
         timestamptz          
------------------------------
 Thu Dec 27 04:05:06 2001 PST
(1 row)

SELECT timestamp with time zone '20011227 040506.789+08';
           timestamptz            
----------------------------------
 Wed Dec 26 12:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '20011227 040506.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '20011227T040506+08';
         timestamptz          
------------------------------
 Wed Dec 26 12:05:06 2001 PST
(1 row)

SELECT timestamp with time zone '20011227T040506-08';
         timestamptz          
------------------------------
 Thu Dec 27 04:05:06 2001 PST
(1 row)

SELECT timestamp with time zone '20011227T040506.789+08';
           timestamptz            
----------------------------------
 Wed Dec 26 12:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '20011227T040506.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '2001-12-27 04:05:06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '2001.12.27 04:05:06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '2001/12/27 04:05:06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '12/27/2001 04:05:06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '27/12/2001 04:05:06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789+08';
           timestamptz            
----------------------------------
 Wed Dec 26 12:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789+08';
           timestamptz            
----------------------------------
 Wed Dec 26 12:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271+08';
         timestamptz          
------------------------------
 Wed Dec 26 08:00:00 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271-08';
         timestamptz          
------------------------------
 Thu Dec 27 00:00:00 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271.5+08';
         timestamptz          
------------------------------
 Wed Dec 26 20:00:00 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271.5-08';
         timestamptz          
------------------------------
 Thu Dec 27 12:00:00 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271 04:05:06+08';
         timestamptz          
------------------------------
 Wed Dec 26 12:05:06 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271 04:05:06-08';
         timestamptz          
------------------------------
 Thu Dec 27 04:05:06 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271T040506+08';
         timestamptz          
------------------------------
 Wed Dec 26 12:05:06 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271T040506-08';
         timestamptz          
------------------------------
 Thu Dec 27 04:05:06 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271T040506.789+08';
           timestamptz            
----------------------------------
 Wed Dec 26 12:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone 'J2452271T040506.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

-- German/European-style dates with periods as delimiters
SELECT timestamp with time zone '27.12.2001 04:05:06.789+08';
           timestamptz            
----------------------------------
 Wed Dec 26 12:05:06.789 2001 PST
(1 row)

SELECT timestamp with time zone '27.12.2001 04:05:06.789-08';
           timestamptz            
----------------------------------
 Thu Dec 27 04:05:06.789 2001 PST
(1 row)

SET DateStyle = 'German';
SELECT timestamp with time zone '27.12.2001 04:05:06.789+08';
         timestamptz         
-----------------------------
 26.12.2001 12:05:06.789 PST
(1 row)

SELECT timestamp with time zone '27.12.2001 04:05:06.789-08';
         timestamptz         
-----------------------------
 27.12.2001 04:05:06.789 PST
(1 row)

SET DateStyle = 'ISO';
-- Reject time without time zone having a time zone specified
SELECT time without time zone '040506.789+08';
ERROR:  Bad time external representation '040506.789+08'
SELECT time without time zone '040506.789-08';
ERROR:  Bad time external representation '040506.789-08'
SELECT time without time zone 'T040506.789+08';
ERROR:  Bad time external representation 'T040506.789+08'
SELECT time without time zone 'T040506.789-08';
ERROR:  Bad time external representation 'T040506.789-08'
SELECT time with time zone '040506.789+08';
      timetz      
------------------
 04:05:06.7890+08
(1 row)

SELECT time with time zone '040506.789-08';
      timetz      
------------------
 04:05:06.7890-08
(1 row)

SELECT time with time zone 'T040506.789+08';
      timetz      
------------------
 04:05:06.7890+08
(1 row)

SELECT time with time zone 'T040506.789-08';
      timetz      
------------------
 04:05:06.7890-08
(1 row)

SELECT time with time zone 'T040506.789 +08';
      timetz      
------------------
 04:05:06.7890+08
(1 row)

SELECT time with time zone 'T040506.789 -08';
      timetz      
------------------
 04:05:06.7890-08
(1 row)

244
SET DateStyle = 'Postgres,US';
245
--
246 247 248
-- date, time arithmetic
--
SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time";
249 250 251
       Date + Time        
--------------------------
 Tue Feb 03 04:05:06 1981
252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277
(1 row)

SELECT date '1991-02-03' + time with time zone '04:05:06 PST' AS "Date + Time PST";
       Date + Time PST        
------------------------------
 Sun Feb 03 04:05:06 1991 PST
(1 row)

SELECT date '2001-02-03' + time with time zone '04:05:06 UTC' AS "Date + Time UTC";
       Date + Time UTC        
------------------------------
 Fri Feb 02 20:05:06 2001 PST
(1 row)

SELECT date '1991-02-03' + interval '2 years' AS "Add Two Years";
        Add Two Years         
------------------------------
 Wed Feb 03 00:00:00 1993 PST
(1 row)

SELECT date '2001-12-13' - interval '2 years' AS "Subtract Two Years";
      Subtract Two Years      
------------------------------
 Mon Dec 13 00:00:00 1999 PST
(1 row)

278
-- subtract time from date should not make sense; use interval instead
279 280 281 282 283 284 285
SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time";
        Subtract Time         
------------------------------
 Sat Feb 02 19:54:54 1991 PST
(1 row)

SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC";
286
ERROR:  Unable to identify an operator '-' for types 'date' and 'time with time zone'
287 288
	You will have to retype this query using an explicit cast
--
289
-- timestamp, interval arithmetic
290
--
291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341
SELECT timestamp without time zone '1996-03-01' - interval '1 second' AS "Feb 29";
          Feb 29          
--------------------------
 Thu Feb 29 23:59:59 1996
(1 row)

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

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

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

-- Shorthand values
-- Not directly usable for regression testing since these are not constants.
-- So, just try to test parser and hope for the best - thomas 97/04/26
SELECT (timestamp without time zone 'today' = (timestamp without time zone 'yesterday' + interval '1 day')) as "True";
 True 
------
 t
(1 row)

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

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

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

342 343 344 345
-- 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";
346 347 348 349 350
     Jan_01_1994_11am     
--------------------------
 Sat Jan 01 11:00:00 1994
(1 row)

351
SELECT date '1994-01-01' + time '10:00' AS "Jan_01_1994_10am";
352 353 354 355 356
     Jan_01_1994_10am     
--------------------------
 Sat Jan 01 10:00:00 1994
(1 row)

357
SELECT date '1994-01-01' + time '11:00-5' AS "Jan_01_1994_8am";
358
ERROR:  Bad time external representation '11:00-5'
359
SELECT "timestamp"(date '1994-01-01', time with time zone '11:00-5') AS "Jan_01_1994_11am";
360 361 362 363 364 365 366 367 368 369 370 371
     Jan_01_1994_11am     
--------------------------
 Sat Jan 01 11:00:00 1994
(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
372 373
    | Tue Feb 10 17:32:01 1998
    | Tue Feb 10 17:32:02 1998
374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440
    | 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 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
441 442
    | Sat Feb 10 17:32:01 1996
    | Sat Feb 10 17:32:02 1996
443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503
    | 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 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";
504 505 506 507 508
            Feb 29            
------------------------------
 Thu Feb 29 23:59:59 1996 PST
(1 row)

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

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

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

527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587
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)

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
588 589
    | Tue Feb 10 17:32:01 1998 PST
    | Tue Feb 10 17:32:02 1998 PST
590 591 592 593 594 595 596 597 598 599
    | 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
Tom Lane's avatar
Tom Lane committed
600
    | Sun Sep 22 18:19:20 2002 PDT
601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633
    | 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 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 PST
    | Sun Feb 16 17:32:01 2098
634
    | Fri Feb 28 17:32:01 1997 PST
635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656
    | 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
657 658
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:02 1996 PST
659 660 661 662 663 664 665 666 667 668
    | 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
Tom Lane's avatar
Tom Lane committed
669
    | Fri Sep 22 18:19:20 2000 PDT
670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702
    | 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
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 17:32:00 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
    | Sat Feb 10 17:32:01 1996 PST
    | Sat Feb 10 09:32:01 1996 PST
    | Sat Feb 10 09:32:01 1996 PST
    | Sat Feb 10 09:32:01 1996 PST
    | Mon Jun 10 18:32:01 1996 PDT
    | Sat Feb 10 17:32:01 1996 PST
    | Sun Feb 11 17:32:01 1996 PST
    | Mon Feb 12 17:32:01 1996 PST
    | Tue Feb 13 17:32:01 1996 PST
    | Wed Feb 14 17:32:01 1996 PST
    | Thu Feb 15 17:32:01 1996 PST
    | Fri Feb 16 17:32:01 1996 PST
    | Mon Feb 16 17:32 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 PST
    | Thu Feb 16 17:32:01 2096
703
    | Tue Feb 28 17:32:01 1995 PST
704 705 706 707 708
    | Tue Feb 28 17:32:01 1995 PST
    | Wed Mar 01 17:32:01 1995 PST
    | Sat Dec 30 17:32:01 1995 PST
    | Sun Dec 31 17:32:01 1995 PST
    | Mon Jan 01 17:32:01 1996 PST
709
    | Wed Feb 28 17:32:01 1996 PST
710 711 712 713 714 715 716 717 718
    | Fri Mar 01 17:32:01 1996 PST
    | Mon Dec 30 17:32:01 1996 PST
    | Tue Dec 31 17:32:01 1996 PST
    | Thu Dec 31 17:32:01 1998 PST
    | Fri Jan 01 17:32:01 1999 PST
    | Fri Dec 31 17:32:01 1999 PST
    | Sat Jan 01 17:32:01 2000 PST
(64 rows)

Tom Lane's avatar
Tom Lane committed
719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757
--
-- time, interval arithmetic
--
SELECT CAST(time '01:02' AS interval) AS "+01:02";
     +01:02      
-----------------
 @ 1 hour 2 mins
(1 row)

SELECT CAST(interval '02:03' AS time) AS "02:03:00";
 02:03:00 
----------
 02:03:00
(1 row)

SELECT time '01:30' + interval '02:01' AS "03:31:00";
 03:31:00 
----------
 03:31:00
(1 row)

SELECT time '01:30' - interval '02:01' AS "23:29:00";
 23:29:00 
----------
 23:29:00
(1 row)

SELECT time '02:30' + interval '36:01' AS "14:31:00";
 14:31:00 
----------
 14:31:00
(1 row)

SELECT time '03:30' + interval '1 month 04:01' AS "07:31:00";
 07:31:00 
----------
 07:31:00
(1 row)

758 759 760 761
SELECT interval '04:30' - time '01:02' AS "20:32:00";
 20:32:00 
----------
 20:32:00
Tom Lane's avatar
Tom Lane committed
762 763 764
(1 row)

SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01";
765
ERROR:  Cannot cast type 'time with time zone' to 'interval'
Tom Lane's avatar
Tom Lane committed
766
SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08";
767
ERROR:  Cannot cast type 'interval' to 'time with time zone'
Tom Lane's avatar
Tom Lane committed
768 769 770 771 772 773 774 775 776 777 778 779
SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08";
 23:29:00-08 
-------------
 23:29:00-08
(1 row)

SELECT time with time zone '02:30-08' + interval '36:01' AS "14:31:00-08";
 14:31:00-08 
-------------
 14:31:00-08
(1 row)

780 781 782 783
-- These two tests cannot be used because they default to current timezone,
-- which may be either -08 or -07 depending on the time of year.
-- SELECT time with time zone '01:30' + interval '02:01' AS "03:31:00-08";
-- SELECT time with time zone '03:30' + interval '1 month 04:01' AS "07:31:00-08";
784
-- Try the following two tests instead, as a poor substitute
785 786
SELECT CAST(CAST(date 'today' + time with time zone '01:30'
            + interval '02:01' AS time with time zone) AS time) AS "03:31:00";
787 788 789 790 791
 03:31:00 
----------
 03:31:00
(1 row)

792
SELECT CAST(cast(date 'today' + time with time zone '03:30'
793
  + interval '1 month 04:01' as timestamp without time zone) AS time) AS "07:31:00";
794 795
 07:31:00 
----------
796
 07:31:00
797 798 799 800 801 802
(1 row)

SELECT interval '04:30' - time with time zone '01:02-05' AS "20:32:00-05";
 20:32:00-05 
-------------
 20:32:00-05
803 804
(1 row)

Tom Lane's avatar
Tom Lane committed
805 806 807
SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
  WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
    AND i.f1 BETWEEN '00:00' AND '23:00';
808 809 810 811
             102             
-----------------------------
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
812 813 814 815
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:02 1997
 Mon Feb 10 22:32:02 1997
816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911
 Mon Feb 10 17:33:01.40 1997
 Mon Feb 10 22:32:01.40 1997
 Mon Feb 10 17:33:01.50 1997
 Mon Feb 10 22:32:01.50 1997
 Mon Feb 10 17:33:01.60 1997
 Mon Feb 10 22:32:01.60 1997
 Thu Jan 02 00:01:00 1997
 Thu Jan 02 05:00:00 1997
 Thu Jan 02 03:05:05 1997
 Thu Jan 02 08:04:05 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Tue Jun 10 17:33:01 1997
 Tue Jun 10 22:32:01 1997
 Wed Mar 15 08:15:01 2000
 Wed Mar 15 13:14:01 2000
 Wed Mar 15 13:15:02 2000
 Wed Mar 15 18:14:02 2000
 Wed Mar 15 12:15:03 2000
 Wed Mar 15 17:14:03 2000
 Wed Mar 15 03:15:04 2000
 Wed Mar 15 08:14:04 2000
 Wed Mar 15 02:15:05 2000
 Wed Mar 15 07:14:05 2000
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:00 1997
 Mon Feb 10 22:32:00 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Tue Jun 10 18:33:01 1997
 Tue Jun 10 23:32:01 1997
 Mon Feb 10 17:33:01 1997
 Mon Feb 10 22:32:01 1997
 Tue Feb 11 17:33:01 1997
 Tue Feb 11 22:32:01 1997
 Wed Feb 12 17:33:01 1997
 Wed Feb 12 22:32:01 1997
 Thu Feb 13 17:33:01 1997
 Thu Feb 13 22:32:01 1997
 Fri Feb 14 17:33:01 1997
 Fri Feb 14 22:32:01 1997
 Sat Feb 15 17:33:01 1997
 Sat Feb 15 22:32:01 1997
 Sun Feb 16 17:33:01 1997
 Sun Feb 16 22:32:01 1997
 Sun Feb 16 17:33:01 1997
 Sun Feb 16 22:32:01 1997
 Wed Feb 28 17:33:01 1996
 Wed Feb 28 22:32:01 1996
 Thu Feb 29 17:33:01 1996
 Thu Feb 29 22:32:01 1996
 Fri Mar 01 17:33:01 1996
 Fri Mar 01 22:32:01 1996
 Mon Dec 30 17:33:01 1996
 Mon Dec 30 22:32:01 1996
 Tue Dec 31 17:33:01 1996
 Tue Dec 31 22:32:01 1996
 Wed Jan 01 17:33:01 1997
 Wed Jan 01 22:32:01 1997
 Fri Feb 28 17:33:01 1997
 Fri Feb 28 22:32:01 1997
 Sat Mar 01 17:33:01 1997
 Sat Mar 01 22:32:01 1997
 Tue Dec 30 17:33:01 1997
 Tue Dec 30 22:32:01 1997
 Wed Dec 31 17:33:01 1997
 Wed Dec 31 22:32:01 1997
 Fri Dec 31 17:33:01 1999
 Fri Dec 31 22:32:01 1999
 Sat Jan 01 17:33:01 2000
 Sat Jan 01 22:32:01 2000
 Sun Dec 31 17:33:01 2000
 Sun Dec 31 22:32:01 2000
Tom Lane's avatar
Tom Lane committed
912 913 914 915 916
(102 rows)

SELECT t.d1 - i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i
  WHERE t.d1 BETWEEN '1990-01-01' AND '2001-01-01'
    AND i.f1 BETWEEN '00:00' AND '23:00';
917 918 919 920
             102             
-----------------------------
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
921 922 923 924
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:02 1997
 Mon Feb 10 12:32:02 1997
925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020
 Mon Feb 10 17:31:01.40 1997
 Mon Feb 10 12:32:01.40 1997
 Mon Feb 10 17:31:01.50 1997
 Mon Feb 10 12:32:01.50 1997
 Mon Feb 10 17:31:01.60 1997
 Mon Feb 10 12:32:01.60 1997
 Wed Jan 01 23:59:00 1997
 Wed Jan 01 19:00:00 1997
 Thu Jan 02 03:03:05 1997
 Wed Jan 01 22:04:05 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Tue Jun 10 17:31:01 1997
 Tue Jun 10 12:32:01 1997
 Wed Mar 15 08:13:01 2000
 Wed Mar 15 03:14:01 2000
 Wed Mar 15 13:13:02 2000
 Wed Mar 15 08:14:02 2000
 Wed Mar 15 12:13:03 2000
 Wed Mar 15 07:14:03 2000
 Wed Mar 15 03:13:04 2000
 Tue Mar 14 22:14:04 2000
 Wed Mar 15 02:13:05 2000
 Tue Mar 14 21:14:05 2000
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:00 1997
 Mon Feb 10 12:32:00 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Tue Jun 10 18:31:01 1997
 Tue Jun 10 13:32:01 1997
 Mon Feb 10 17:31:01 1997
 Mon Feb 10 12:32:01 1997
 Tue Feb 11 17:31:01 1997
 Tue Feb 11 12:32:01 1997
 Wed Feb 12 17:31:01 1997
 Wed Feb 12 12:32:01 1997
 Thu Feb 13 17:31:01 1997
 Thu Feb 13 12:32:01 1997
 Fri Feb 14 17:31:01 1997
 Fri Feb 14 12:32:01 1997
 Sat Feb 15 17:31:01 1997
 Sat Feb 15 12:32:01 1997
 Sun Feb 16 17:31:01 1997
 Sun Feb 16 12:32:01 1997
 Sun Feb 16 17:31:01 1997
 Sun Feb 16 12:32:01 1997
 Wed Feb 28 17:31:01 1996
 Wed Feb 28 12:32:01 1996
 Thu Feb 29 17:31:01 1996
 Thu Feb 29 12:32:01 1996
 Fri Mar 01 17:31:01 1996
 Fri Mar 01 12:32:01 1996
 Mon Dec 30 17:31:01 1996
 Mon Dec 30 12:32:01 1996
 Tue Dec 31 17:31:01 1996
 Tue Dec 31 12:32:01 1996
 Wed Jan 01 17:31:01 1997
 Wed Jan 01 12:32:01 1997
 Fri Feb 28 17:31:01 1997
 Fri Feb 28 12:32:01 1997
 Sat Mar 01 17:31:01 1997
 Sat Mar 01 12:32:01 1997
 Tue Dec 30 17:31:01 1997
 Tue Dec 30 12:32:01 1997
 Wed Dec 31 17:31:01 1997
 Wed Dec 31 12:32:01 1997
 Fri Dec 31 17:31:01 1999
 Fri Dec 31 12:32:01 1999
 Sat Jan 01 17:31:01 2000
 Sat Jan 01 12:32:01 2000
 Sun Dec 31 17:31:01 2000
 Sun Dec 31 12:32:01 2000
Tom Lane's avatar
Tom Lane committed
1021 1022 1023
(102 rows)

SELECT t.f1 + i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
1024 1025
     80      
-------------
Tom Lane's avatar
Tom Lane committed
1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095
 00:01:00
 05:00:00
 00:00:00
 00:00:00
 00:00:00
 23:59:46
 02:03:04
 00:00:00
 00:00:00
 12:00:00
 01:01:00
 06:00:00
 01:00:00
 01:00:00
 01:00:00
 00:59:46
 03:03:04
 01:00:00
 01:00:00
 13:00:00
 02:04:00
 07:03:00
 02:03:00
 02:03:00
 02:03:00
 02:02:46
 04:06:04
 02:03:00
 02:03:00
 14:03:00
 12:00:00
 16:59:00
 11:59:00
 11:59:00
 11:59:00
 11:58:46
 14:02:04
 11:59:00
 11:59:00
 23:59:00
 12:01:00
 17:00:00
 12:00:00
 12:00:00
 12:00:00
 11:59:46
 14:03:04
 12:00:00
 12:00:00
 00:00:00
 12:02:00
 17:01:00
 12:01:00
 12:01:00
 12:01:00
 12:00:46
 14:04:04
 12:01:00
 12:01:00
 00:01:00
 00:00:00
 04:59:00
 23:59:00
 23:59:00
 23:59:00
 23:58:46
 02:02:04
 23:59:00
 23:59:00
 11:59:00
1096 1097 1098 1099 1100 1101 1102 1103 1104 1105
 00:00:59.99
 04:59:59.99
 23:59:59.99
 23:59:59.99
 23:59:59.99
 23:59:45.99
 02:03:03.99
 23:59:59.99
 23:59:59.99
 11:59:59.99
Tom Lane's avatar
Tom Lane committed
1106 1107 1108
(80 rows)

SELECT t.f1 - i.f1 AS "80" FROM TIME_TBL t, INTERVAL_TBL i;
1109 1110
     80      
-------------
Tom Lane's avatar
Tom Lane committed
1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180
 23:59:00
 19:00:00
 00:00:00
 00:00:00
 00:00:00
 00:00:14
 21:56:56
 00:00:00
 00:00:00
 12:00:00
 00:59:00
 20:00:00
 01:00:00
 01:00:00
 01:00:00
 01:00:14
 22:56:56
 01:00:00
 01:00:00
 13:00:00
 02:02:00
 21:03:00
 02:03:00
 02:03:00
 02:03:00
 02:03:14
 23:59:56
 02:03:00
 02:03:00
 14:03:00
 11:58:00
 06:59:00
 11:59:00
 11:59:00
 11:59:00
 11:59:14
 09:55:56
 11:59:00
 11:59:00
 23:59:00
 11:59:00
 07:00:00
 12:00:00
 12:00:00
 12:00:00
 12:00:14
 09:56:56
 12:00:00
 12:00:00
 00:00:00
 12:00:00
 07:01:00
 12:01:00
 12:01:00
 12:01:00
 12:01:14
 09:57:56
 12:01:00
 12:01:00
 00:01:00
 23:58:00
 18:59:00
 23:59:00
 23:59:00
 23:59:00
 23:59:14
 21:55:56
 23:59:00
 23:59:00
 11:59:00
1181 1182 1183 1184 1185 1186 1187 1188 1189 1190
 23:58:59.99
 18:59:59.99
 23:59:59.99
 23:59:59.99
 23:59:59.99
 00:00:13.99
 21:56:55.99
 23:59:59.99
 23:59:59.99
 11:59:59.99
Tom Lane's avatar
Tom Lane committed
1191 1192
(80 rows)

1193
SELECT t.f1 + i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
1194 1195
      100       
----------------
1196 1197
 00:02:00-07
 05:01:00-07
Tom Lane's avatar
Tom Lane committed
1198
 00:01:00-07
1199 1200 1201 1202 1203 1204 1205
 00:01:00-07
 00:01:00-07
 00:00:46-07
 02:04:04-07
 00:01:00-07
 00:01:00-07
 12:01:00-07
Tom Lane's avatar
Tom Lane committed
1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225
 01:01:00-07
 06:00:00-07
 01:00:00-07
 01:00:00-07
 01:00:00-07
 00:59:46-07
 03:03:04-07
 01:00:00-07
 01:00:00-07
 13:00:00-07
 02:04:00-07
 07:03:00-07
 02:03:00-07
 02:03:00-07
 02:03:00-07
 02:02:46-07
 04:06:04-07
 02:03:00-07
 02:03:00-07
 14:03:00-07
1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245
 07:08:00-08
 12:07:00-08
 07:07:00-08
 07:07:00-08
 07:07:00-08
 07:06:46-08
 09:10:04-08
 07:07:00-08
 07:07:00-08
 19:07:00-08
 08:09:00-04
 13:08:00-04
 08:08:00-04
 08:08:00-04
 08:08:00-04
 08:07:46-04
 10:11:04-04
 08:08:00-04
 08:08:00-04
 20:08:00-04
Tom Lane's avatar
Tom Lane committed
1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285
 12:00:00-07
 16:59:00-07
 11:59:00-07
 11:59:00-07
 11:59:00-07
 11:58:46-07
 14:02:04-07
 11:59:00-07
 11:59:00-07
 23:59:00-07
 12:01:00-07
 17:00:00-07
 12:00:00-07
 12:00:00-07
 12:00:00-07
 11:59:46-07
 14:03:04-07
 12:00:00-07
 12:00:00-07
 00:00:00-07
 12:02:00-07
 17:01:00-07
 12:01:00-07
 12:01:00-07
 12:01:00-07
 12:00:46-07
 14:04:04-07
 12:01:00-07
 12:01:00-07
 00:01:00-07
 00:00:00-07
 04:59:00-07
 23:59:00-07
 23:59:00-07
 23:59:00-07
 23:58:46-07
 02:02:04-07
 23:59:00-07
 23:59:00-07
 11:59:00-07
1286 1287 1288 1289 1290 1291 1292 1293 1294 1295
 00:00:59.99-07
 04:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 23:59:45.99-07
 02:03:03.99-07
 23:59:59.99-07
 23:59:59.99-07
 11:59:59.99-07
1296
(100 rows)
Tom Lane's avatar
Tom Lane committed
1297

1298
SELECT t.f1 - i.f1 AS "100" FROM TIMETZ_TBL t, INTERVAL_TBL i;
1299 1300
      100       
----------------
Tom Lane's avatar
Tom Lane committed
1301
 00:00:00-07
1302 1303 1304 1305 1306 1307 1308 1309 1310
 19:01:00-07
 00:01:00-07
 00:01:00-07
 00:01:00-07
 00:01:14-07
 21:57:56-07
 00:01:00-07
 00:01:00-07
 12:01:00-07
Tom Lane's avatar
Tom Lane committed
1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330
 00:59:00-07
 20:00:00-07
 01:00:00-07
 01:00:00-07
 01:00:00-07
 01:00:14-07
 22:56:56-07
 01:00:00-07
 01:00:00-07
 13:00:00-07
 02:02:00-07
 21:03:00-07
 02:03:00-07
 02:03:00-07
 02:03:00-07
 02:03:14-07
 23:59:56-07
 02:03:00-07
 02:03:00-07
 14:03:00-07
1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350
 07:06:00-08
 02:07:00-08
 07:07:00-08
 07:07:00-08
 07:07:00-08
 07:07:14-08
 05:03:56-08
 07:07:00-08
 07:07:00-08
 19:07:00-08
 08:07:00-04
 03:08:00-04
 08:08:00-04
 08:08:00-04
 08:08:00-04
 08:08:14-04
 06:04:56-04
 08:08:00-04
 08:08:00-04
 20:08:00-04
Tom Lane's avatar
Tom Lane committed
1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390
 11:58:00-07
 06:59:00-07
 11:59:00-07
 11:59:00-07
 11:59:00-07
 11:59:14-07
 09:55:56-07
 11:59:00-07
 11:59:00-07
 23:59:00-07
 11:59:00-07
 07:00:00-07
 12:00:00-07
 12:00:00-07
 12:00:00-07
 12:00:14-07
 09:56:56-07
 12:00:00-07
 12:00:00-07
 00:00:00-07
 12:00:00-07
 07:01:00-07
 12:01:00-07
 12:01:00-07
 12:01:00-07
 12:01:14-07
 09:57:56-07
 12:01:00-07
 12:01:00-07
 00:01:00-07
 23:58:00-07
 18:59:00-07
 23:59:00-07
 23:59:00-07
 23:59:00-07
 23:59:14-07
 21:55:56-07
 23:59:00-07
 23:59:00-07
 11:59:00-07
1391 1392 1393 1394 1395 1396 1397 1398 1399 1400
 23:58:59.99-07
 18:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 23:59:59.99-07
 00:00:13.99-07
 21:56:55.99-07
 23:59:59.99-07
 23:59:59.99-07
 11:59:59.99-07
1401
(100 rows)
Tom Lane's avatar
Tom Lane committed
1402 1403

-- SQL9x OVERLAPS operator
1404 1405 1406
-- test with time zone
SELECT (timestamp with time zone '2000-11-27', timestamp with time zone '2000-11-28')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "True";
Tom Lane's avatar
Tom Lane committed
1407 1408 1409 1410 1411
 True 
------
 t
(1 row)

1412 1413
SELECT (timestamp with time zone '2000-11-26', timestamp with time zone '2000-11-27')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "False";
Tom Lane's avatar
Tom Lane committed
1414 1415 1416 1417 1418
 False 
-------
 f
(1 row)

1419 1420
SELECT (timestamp with time zone '2000-11-27', timestamp with time zone '2000-11-28')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', interval '1 day') AS "True";
Tom Lane's avatar
Tom Lane committed
1421 1422 1423 1424 1425
 True 
------
 t
(1 row)

1426 1427
SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', timestamp with time zone '2000-11-30') AS "False";
Tom Lane's avatar
Tom Lane committed
1428 1429 1430 1431 1432
 False 
-------
 f
(1 row)

1433 1434
SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp with time zone '2000-11-27', interval '12 hours') AS "True";
Tom Lane's avatar
Tom Lane committed
1435 1436 1437 1438 1439
 True 
------
 t
(1 row)

1440 1441
SELECT (timestamp with time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp with time zone '2000-11-27 12:00', interval '12 hours') AS "False";
Tom Lane's avatar
Tom Lane committed
1442 1443 1444 1445 1446
 False 
-------
 f
(1 row)

1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490
-- test without time zone
SELECT (timestamp without time zone '2000-11-27', timestamp without time zone '2000-11-28')
  OVERLAPS (timestamp without time zone '2000-11-27 12:00', timestamp without time zone '2000-11-30') AS "True";
 True 
------
 t
(1 row)

SELECT (timestamp without time zone '2000-11-26', timestamp without time zone '2000-11-27')
  OVERLAPS (timestamp without time zone '2000-11-27 12:00', timestamp without time zone '2000-11-30') AS "False";
 False 
-------
 f
(1 row)

SELECT (timestamp without time zone '2000-11-27', timestamp without time zone '2000-11-28')
  OVERLAPS (timestamp without time zone '2000-11-27 12:00', interval '1 day') AS "True";
 True 
------
 t
(1 row)

SELECT (timestamp without time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp without time zone '2000-11-27 12:00', timestamp without time zone '2000-11-30') AS "False";
 False 
-------
 f
(1 row)

SELECT (timestamp without time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp without time zone '2000-11-27', interval '12 hours') AS "True";
 True 
------
 t
(1 row)

SELECT (timestamp without time zone '2000-11-27', interval '12 hours')
  OVERLAPS (timestamp without time zone '2000-11-27 12:00', interval '12 hours') AS "False";
 False 
-------
 f
(1 row)

-- test time and interval
Tom Lane's avatar
Tom Lane committed
1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511
SELECT (time '00:00', time '01:00')
  OVERLAPS (time '00:30', time '01:30') AS "True";
 True 
------
 t
(1 row)

SELECT (time '00:00', interval '1 hour')
  OVERLAPS (time '00:30', interval '1 hour') AS "True";
 True 
------
 t
(1 row)

SELECT (time '00:00', interval '1 hour')
  OVERLAPS (time '01:30', interval '1 hour') AS "False";
 False 
-------
 f
(1 row)

1512 1513 1514
-- SQL99 seems to want this to be false (and we conform to the spec).
-- istm that this *should* return true, on the theory that time
-- intervals can wrap around the day boundary - thomas 2001-09-25
Tom Lane's avatar
Tom Lane committed
1515
SELECT (time '00:00', interval '1 hour')
1516 1517 1518
  OVERLAPS (time '01:30', interval '1 day') AS "False";
 False 
-------
Tom Lane's avatar
Tom Lane committed
1519 1520 1521
 f
(1 row)

1522
CREATE TABLE TEMP_TIMESTAMP (f1 timestamp);
1523
-- get some candidate input values
1524 1525
INSERT INTO TEMP_TIMESTAMP (f1)
  SELECT d1 FROM TIMESTAMP_TBL
1526 1527
  WHERE d1 BETWEEN '13-jun-1957' AND '1-jan-1997'
   OR d1 BETWEEN '1-jan-1999' AND '1-jan-2010';
1528
SELECT '' AS "16", f1 AS "timestamp"
1529
  FROM TEMP_TIMESTAMP
1530
  ORDER BY "timestamp";
1531
 16 |          timestamp           
1532
----+------------------------------
1533
    | Thu Jan 01 00:00:00 1970 PST
1534 1535 1536 1537 1538 1539 1540
    | 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
    | Fri Dec 31 17:32:01 1999 PST
    | Sat Jan 01 17:32:01 2000 PST
1541
    | Wed Mar 15 02:14:05 2000 PST
1542 1543
    | Wed Mar 15 03:14:04 2000 PST
    | Wed Mar 15 08:14:01 2000 PST
1544 1545
    | Wed Mar 15 12:14:03 2000 PST
    | Wed Mar 15 13:14:02 2000 PST
1546 1547
    | Sun Dec 31 17:32:01 2000 PST
    | Mon Jan 01 17:32:01 2001 PST
1548 1549
    | Sat Sep 22 18:19:20 2001 PDT
(16 rows)
1550

Tom Lane's avatar
Tom Lane committed
1551
SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 + t.f1 AS plus
1552
  FROM TEMP_TIMESTAMP d, INTERVAL_TBL t
Tom Lane's avatar
Tom Lane committed
1553
  ORDER BY plus, "timestamp", "interval";
1554
 160 |          timestamp           |           interval            |             plus             
1555
-----+------------------------------+-------------------------------+------------------------------
1556 1557 1558 1559 1560 1561
     | Thu Jan 01 00:00:00 1970 PST | @ 14 secs ago                 | Wed Dec 31 23:59:46 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 1 min                       | Thu Jan 01 00:01:00 1970 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 5 hours                     | Thu Jan 01 05:00:00 1970 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Jan 02 02:03:04 1970 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 10 days                     | Sun Jan 11 00:00:00 1970 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 3 mons                      | Wed Apr 01 00:00:00 1970 PST
1562 1563
     | Thu Jan 01 00:00:00 1970 PST | @ 5 mons                      | Mon Jun 01 00:00:00 1970 PDT
     | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours             | Mon Jun 01 12:00:00 1970 PDT
1564
     | Thu Jan 01 00:00:00 1970 PST | @ 6 years                     | Thu Jan 01 00:00:00 1976 PST
1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579
     | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago                 | Wed Feb 28 17:31:47 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 1 min                       | Wed Feb 28 17:33:01 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 5 hours                     | Wed Feb 28 22:32:01 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago                 | Thu Feb 29 17:31:47 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 1 min                       | Thu Feb 29 17:33:01 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 19:35:05 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 5 hours                     | Thu Feb 29 22:32:01 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago                 | Fri Mar 01 17:31:47 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 1 min                       | Fri Mar 01 17:33:01 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Mar 01 19:35:05 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 5 hours                     | Fri Mar 01 22:32:01 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Mar 02 19:35:05 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 10 days                     | Sat Mar 09 17:32:01 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 10 days                     | Sun Mar 10 17:32:01 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 10 days                     | Mon Mar 11 17:32:01 1996 PST
1580 1581 1582 1583 1584 1585 1586 1587 1588
     | Wed Feb 28 17:32:01 1996 PST | @ 3 mons                      | Tue May 28 17:32:01 1996 PDT
     | Thu Feb 29 17:32:01 1996 PST | @ 3 mons                      | Wed May 29 17:32:01 1996 PDT
     | Fri Mar 01 17:32:01 1996 PST | @ 3 mons                      | Sat Jun 01 17:32:01 1996 PDT
     | Wed Feb 28 17:32:01 1996 PST | @ 5 mons                      | Sun Jul 28 17:32:01 1996 PDT
     | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours             | Mon Jul 29 05:32:01 1996 PDT
     | Thu Feb 29 17:32:01 1996 PST | @ 5 mons                      | Mon Jul 29 17:32:01 1996 PDT
     | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours             | Tue Jul 30 05:32:01 1996 PDT
     | Fri Mar 01 17:32:01 1996 PST | @ 5 mons                      | Thu Aug 01 17:32:01 1996 PDT
     | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours             | Fri Aug 02 05:32:01 1996 PDT
1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600
     | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago                 | Mon Dec 30 17:31:47 1996 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 1 min                       | Mon Dec 30 17:33:01 1996 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 5 hours                     | Mon Dec 30 22:32:01 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago                 | Tue Dec 31 17:31:47 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 1 min                       | Tue Dec 31 17:33:01 1996 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 31 19:35:05 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 5 hours                     | Tue Dec 31 22:32:01 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Jan 01 19:35:05 1997 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 10 days                     | Thu Jan 09 17:32:01 1997 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 10 days                     | Fri Jan 10 17:32:01 1997 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 3 mons                      | Sun Mar 30 17:32:01 1997 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 3 mons                      | Mon Mar 31 17:32:01 1997 PST
1601 1602 1603 1604
     | Mon Dec 30 17:32:01 1996 PST | @ 5 mons                      | Fri May 30 17:32:01 1997 PDT
     | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours             | Sat May 31 05:32:01 1997 PDT
     | Tue Dec 31 17:32:01 1996 PST | @ 5 mons                      | Sat May 31 17:32:01 1997 PDT
     | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours             | Sun Jun 01 05:32:01 1997 PDT
1605 1606 1607 1608 1609 1610 1611 1612 1613 1614
     | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago                 | Fri Dec 31 17:31:47 1999 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 1 min                       | Fri Dec 31 17:33:01 1999 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 5 hours                     | Fri Dec 31 22:32:01 1999 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago                 | Sat Jan 01 17:31:47 2000 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 1 min                       | Sat Jan 01 17:33:01 2000 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Jan 01 19:35:05 2000 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 5 hours                     | Sat Jan 01 22:32:01 2000 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Jan 02 19:35:05 2000 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 10 days                     | Mon Jan 10 17:32:01 2000 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 10 days                     | Tue Jan 11 17:32:01 2000 PST
1615 1616
     | Wed Mar 15 02:14:05 2000 PST | @ 14 secs ago                 | Wed Mar 15 02:13:51 2000 PST
     | Wed Mar 15 02:14:05 2000 PST | @ 1 min                       | Wed Mar 15 02:15:05 2000 PST
1617 1618
     | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago                 | Wed Mar 15 03:13:50 2000 PST
     | Wed Mar 15 03:14:04 2000 PST | @ 1 min                       | Wed Mar 15 03:15:04 2000 PST
1619
     | Wed Mar 15 02:14:05 2000 PST | @ 5 hours                     | Wed Mar 15 07:14:05 2000 PST
1620 1621 1622
     | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago                 | Wed Mar 15 08:13:47 2000 PST
     | Wed Mar 15 03:14:04 2000 PST | @ 5 hours                     | Wed Mar 15 08:14:04 2000 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 1 min                       | Wed Mar 15 08:15:01 2000 PST
1623 1624 1625
     | Wed Mar 15 12:14:03 2000 PST | @ 14 secs ago                 | Wed Mar 15 12:13:49 2000 PST
     | Wed Mar 15 12:14:03 2000 PST | @ 1 min                       | Wed Mar 15 12:15:03 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 14 secs ago                 | Wed Mar 15 13:13:48 2000 PST
1626
     | Wed Mar 15 08:14:01 2000 PST | @ 5 hours                     | Wed Mar 15 13:14:01 2000 PST
1627 1628 1629 1630
     | Wed Mar 15 13:14:02 2000 PST | @ 1 min                       | Wed Mar 15 13:15:02 2000 PST
     | Wed Mar 15 12:14:03 2000 PST | @ 5 hours                     | Wed Mar 15 17:14:03 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 5 hours                     | Wed Mar 15 18:14:02 2000 PST
     | Wed Mar 15 02:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 04:17:09 2000 PST
1631 1632
     | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 05:17:08 2000 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 10:17:05 2000 PST
1633 1634 1635
     | Wed Mar 15 12:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 14:17:07 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Mar 16 15:17:06 2000 PST
     | Wed Mar 15 02:14:05 2000 PST | @ 10 days                     | Sat Mar 25 02:14:05 2000 PST
1636 1637
     | Wed Mar 15 03:14:04 2000 PST | @ 10 days                     | Sat Mar 25 03:14:04 2000 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 10 days                     | Sat Mar 25 08:14:01 2000 PST
1638 1639
     | Wed Mar 15 12:14:03 2000 PST | @ 10 days                     | Sat Mar 25 12:14:03 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 10 days                     | Sat Mar 25 13:14:02 2000 PST
1640 1641
     | Fri Dec 31 17:32:01 1999 PST | @ 3 mons                      | Fri Mar 31 17:32:01 2000 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 3 mons                      | Sat Apr 01 17:32:01 2000 PST
1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660
     | Fri Dec 31 17:32:01 1999 PST | @ 5 mons                      | Wed May 31 17:32:01 2000 PDT
     | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours             | Thu Jun 01 05:32:01 2000 PDT
     | Sat Jan 01 17:32:01 2000 PST | @ 5 mons                      | Thu Jun 01 17:32:01 2000 PDT
     | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours             | Fri Jun 02 05:32:01 2000 PDT
     | Wed Mar 15 02:14:05 2000 PST | @ 3 mons                      | Thu Jun 15 02:14:05 2000 PDT
     | Wed Mar 15 03:14:04 2000 PST | @ 3 mons                      | Thu Jun 15 03:14:04 2000 PDT
     | Wed Mar 15 08:14:01 2000 PST | @ 3 mons                      | Thu Jun 15 08:14:01 2000 PDT
     | Wed Mar 15 12:14:03 2000 PST | @ 3 mons                      | Thu Jun 15 12:14:03 2000 PDT
     | Wed Mar 15 13:14:02 2000 PST | @ 3 mons                      | Thu Jun 15 13:14:02 2000 PDT
     | Wed Mar 15 02:14:05 2000 PST | @ 5 mons                      | Tue Aug 15 02:14:05 2000 PDT
     | Wed Mar 15 03:14:04 2000 PST | @ 5 mons                      | Tue Aug 15 03:14:04 2000 PDT
     | Wed Mar 15 08:14:01 2000 PST | @ 5 mons                      | Tue Aug 15 08:14:01 2000 PDT
     | Wed Mar 15 12:14:03 2000 PST | @ 5 mons                      | Tue Aug 15 12:14:03 2000 PDT
     | Wed Mar 15 13:14:02 2000 PST | @ 5 mons                      | Tue Aug 15 13:14:02 2000 PDT
     | Wed Mar 15 02:14:05 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 14:14:05 2000 PDT
     | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 15:14:04 2000 PDT
     | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours             | Tue Aug 15 20:14:01 2000 PDT
     | Wed Mar 15 12:14:03 2000 PST | @ 5 mons 12 hours             | Wed Aug 16 00:14:03 2000 PDT
     | Wed Mar 15 13:14:02 2000 PST | @ 5 mons 12 hours             | Wed Aug 16 01:14:02 2000 PDT
1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671
     | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago                 | Sun Dec 31 17:31:47 2000 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 1 min                       | Sun Dec 31 17:33:01 2000 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 5 hours                     | Sun Dec 31 22:32:01 2000 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago                 | Mon Jan 01 17:31:47 2001 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 1 min                       | Mon Jan 01 17:33:01 2001 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Jan 01 19:35:05 2001 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 5 hours                     | Mon Jan 01 22:32:01 2001 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Jan 02 19:35:05 2001 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 10 days                     | Wed Jan 10 17:32:01 2001 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 10 days                     | Thu Jan 11 17:32:01 2001 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 3 mons                      | Sat Mar 31 17:32:01 2001 PST
1672 1673 1674 1675 1676
     | Mon Jan 01 17:32:01 2001 PST | @ 3 mons                      | Sun Apr 01 17:32:01 2001 PDT
     | Sun Dec 31 17:32:01 2000 PST | @ 5 mons                      | Thu May 31 17:32:01 2001 PDT
     | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours             | Fri Jun 01 05:32:01 2001 PDT
     | Mon Jan 01 17:32:01 2001 PST | @ 5 mons                      | Fri Jun 01 17:32:01 2001 PDT
     | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours             | Sat Jun 02 05:32:01 2001 PDT
1677 1678 1679 1680 1681
     | Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago                 | Sat Sep 22 18:19:06 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 1 min                       | Sat Sep 22 18:20:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 5 hours                     | Sat Sep 22 23:19:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 1 day 2 hours 3 mins 4 secs | Sun Sep 23 20:22:24 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 10 days                     | Tue Oct 02 18:19:20 2001 PDT
1682 1683 1684 1685
     | Sat Sep 22 18:19:20 2001 PDT | @ 3 mons                      | Sat Dec 22 18:19:20 2001 PST
     | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons                      | Fri Feb 22 18:19:20 2002 PST
     | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons 12 hours             | Sat Feb 23 06:19:20 2002 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 6 years                     | Thu Feb 28 17:32:01 2002 PST
1686 1687 1688 1689
     | Thu Feb 29 17:32:01 1996 PST | @ 6 years                     | Thu Feb 28 17:32:01 2002 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 6 years                     | Fri Mar 01 17:32:01 2002 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 6 years                     | Mon Dec 30 17:32:01 2002 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 6 years                     | Tue Dec 31 17:32:01 2002 PST
1690
     | Thu Jan 01 00:00:00 1970 PST | @ 34 years                    | Thu Jan 01 00:00:00 2004 PST
1691 1692
     | Fri Dec 31 17:32:01 1999 PST | @ 6 years                     | Sat Dec 31 17:32:01 2005 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 6 years                     | Sun Jan 01 17:32:01 2006 PST
1693
     | Wed Mar 15 02:14:05 2000 PST | @ 6 years                     | Wed Mar 15 02:14:05 2006 PST
1694 1695
     | Wed Mar 15 03:14:04 2000 PST | @ 6 years                     | Wed Mar 15 03:14:04 2006 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 6 years                     | Wed Mar 15 08:14:01 2006 PST
1696 1697
     | Wed Mar 15 12:14:03 2000 PST | @ 6 years                     | Wed Mar 15 12:14:03 2006 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 6 years                     | Wed Mar 15 13:14:02 2006 PST
1698 1699
     | Sun Dec 31 17:32:01 2000 PST | @ 6 years                     | Sun Dec 31 17:32:01 2006 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 6 years                     | Mon Jan 01 17:32:01 2007 PST
1700
     | Sat Sep 22 18:19:20 2001 PDT | @ 6 years                     | Sat Sep 22 18:19:20 2007 PDT
1701
     | Wed Feb 28 17:32:01 1996 PST | @ 34 years                    | Thu Feb 28 17:32:01 2030 PST
1702 1703 1704 1705 1706 1707
     | Thu Feb 29 17:32:01 1996 PST | @ 34 years                    | Thu Feb 28 17:32:01 2030 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 34 years                    | Fri Mar 01 17:32:01 2030 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 34 years                    | Mon Dec 30 17:32:01 2030 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 34 years                    | Tue Dec 31 17:32:01 2030 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 34 years                    | Sat Dec 31 17:32:01 2033 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 34 years                    | Sun Jan 01 17:32:01 2034 PST
1708
     | Wed Mar 15 02:14:05 2000 PST | @ 34 years                    | Wed Mar 15 02:14:05 2034 PST
1709 1710
     | Wed Mar 15 03:14:04 2000 PST | @ 34 years                    | Wed Mar 15 03:14:04 2034 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 34 years                    | Wed Mar 15 08:14:01 2034 PST
1711 1712
     | Wed Mar 15 12:14:03 2000 PST | @ 34 years                    | Wed Mar 15 12:14:03 2034 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 34 years                    | Wed Mar 15 13:14:02 2034 PST
1713 1714
     | Sun Dec 31 17:32:01 2000 PST | @ 34 years                    | Sun Dec 31 17:32:01 2034 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 34 years                    | Mon Jan 01 17:32:01 2035 PST
1715 1716
     | Sat Sep 22 18:19:20 2001 PDT | @ 34 years                    | Sat Sep 22 18:19:20 2035 PDT
(160 rows)
1717

Tom Lane's avatar
Tom Lane committed
1718
SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 - t.f1 AS minus
1719
  FROM TEMP_TIMESTAMP d, INTERVAL_TBL t
1720
  WHERE isfinite(d.f1)
Tom Lane's avatar
Tom Lane committed
1721
  ORDER BY minus, "timestamp", "interval";
1722
 160 |          timestamp           |           interval            |            minus             
1723
-----+------------------------------+-------------------------------+------------------------------
1724
     | Thu Jan 01 00:00:00 1970 PST | @ 34 years                    | Wed Jan 01 00:00:00 1936 PST
1725
     | Wed Feb 28 17:32:01 1996 PST | @ 34 years                    | Wed Feb 28 17:32:01 1962 PST
1726 1727 1728 1729
     | Thu Feb 29 17:32:01 1996 PST | @ 34 years                    | Wed Feb 28 17:32:01 1962 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 34 years                    | Thu Mar 01 17:32:01 1962 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 34 years                    | Sun Dec 30 17:32:01 1962 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 34 years                    | Mon Dec 31 17:32:01 1962 PST
1730
     | Thu Jan 01 00:00:00 1970 PST | @ 6 years                     | Wed Jan 01 00:00:00 1964 PST
1731 1732
     | Fri Dec 31 17:32:01 1999 PST | @ 34 years                    | Fri Dec 31 17:32:01 1965 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 34 years                    | Sat Jan 01 17:32:01 1966 PST
1733
     | Wed Mar 15 02:14:05 2000 PST | @ 34 years                    | Tue Mar 15 02:14:05 1966 PST
1734 1735
     | Wed Mar 15 03:14:04 2000 PST | @ 34 years                    | Tue Mar 15 03:14:04 1966 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 34 years                    | Tue Mar 15 08:14:01 1966 PST
1736 1737
     | Wed Mar 15 12:14:03 2000 PST | @ 34 years                    | Tue Mar 15 12:14:03 1966 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 34 years                    | Tue Mar 15 13:14:02 1966 PST
1738 1739
     | Sun Dec 31 17:32:01 2000 PST | @ 34 years                    | Sat Dec 31 17:32:01 1966 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 34 years                    | Sun Jan 01 17:32:01 1967 PST
1740
     | Sat Sep 22 18:19:20 2001 PDT | @ 34 years                    | Fri Sep 22 18:19:20 1967 PST
1741 1742 1743 1744 1745 1746 1747 1748
     | Thu Jan 01 00:00:00 1970 PST | @ 5 mons 12 hours             | Thu Jul 31 12:00:00 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 5 mons                      | Fri Aug 01 00:00:00 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 3 mons                      | Wed Oct 01 00:00:00 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 10 days                     | Mon Dec 22 00:00:00 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Dec 30 21:56:56 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 5 hours                     | Wed Dec 31 19:00:00 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 1 min                       | Wed Dec 31 23:59:00 1969 PST
     | Thu Jan 01 00:00:00 1970 PST | @ 14 secs ago                 | Thu Jan 01 00:00:14 1970 PST
1749
     | Wed Feb 28 17:32:01 1996 PST | @ 6 years                     | Wed Feb 28 17:32:01 1990 PST
1750 1751 1752 1753 1754 1755
     | Thu Feb 29 17:32:01 1996 PST | @ 6 years                     | Wed Feb 28 17:32:01 1990 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 6 years                     | Thu Mar 01 17:32:01 1990 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 6 years                     | Sun Dec 30 17:32:01 1990 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 6 years                     | Mon Dec 31 17:32:01 1990 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 6 years                     | Fri Dec 31 17:32:01 1993 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 6 years                     | Sat Jan 01 17:32:01 1994 PST
1756
     | Wed Mar 15 02:14:05 2000 PST | @ 6 years                     | Tue Mar 15 02:14:05 1994 PST
1757 1758
     | Wed Mar 15 03:14:04 2000 PST | @ 6 years                     | Tue Mar 15 03:14:04 1994 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 6 years                     | Tue Mar 15 08:14:01 1994 PST
1759 1760
     | Wed Mar 15 12:14:03 2000 PST | @ 6 years                     | Tue Mar 15 12:14:03 1994 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 6 years                     | Tue Mar 15 13:14:02 1994 PST
1761 1762
     | Sun Dec 31 17:32:01 2000 PST | @ 6 years                     | Sat Dec 31 17:32:01 1994 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 6 years                     | Sun Jan 01 17:32:01 1995 PST
1763
     | Sat Sep 22 18:19:20 2001 PDT | @ 6 years                     | Fri Sep 22 18:19:20 1995 PDT
1764 1765 1766 1767 1768 1769
     | Wed Feb 28 17:32:01 1996 PST | @ 5 mons 12 hours             | Thu Sep 28 05:32:01 1995 PDT
     | Wed Feb 28 17:32:01 1996 PST | @ 5 mons                      | Thu Sep 28 17:32:01 1995 PDT
     | Thu Feb 29 17:32:01 1996 PST | @ 5 mons 12 hours             | Fri Sep 29 05:32:01 1995 PDT
     | Thu Feb 29 17:32:01 1996 PST | @ 5 mons                      | Fri Sep 29 17:32:01 1995 PDT
     | Fri Mar 01 17:32:01 1996 PST | @ 5 mons 12 hours             | Sun Oct 01 05:32:01 1995 PDT
     | Fri Mar 01 17:32:01 1996 PST | @ 5 mons                      | Sun Oct 01 17:32:01 1995 PDT
1770
     | Wed Feb 28 17:32:01 1996 PST | @ 3 mons                      | Tue Nov 28 17:32:01 1995 PST
1771
     | Thu Feb 29 17:32:01 1996 PST | @ 3 mons                      | Wed Nov 29 17:32:01 1995 PST
1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787
     | Fri Mar 01 17:32:01 1996 PST | @ 3 mons                      | Fri Dec 01 17:32:01 1995 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 10 days                     | Sun Feb 18 17:32:01 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 10 days                     | Mon Feb 19 17:32:01 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 10 days                     | Tue Feb 20 17:32:01 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Feb 27 15:28:57 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 5 hours                     | Wed Feb 28 12:32:01 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Wed Feb 28 15:28:57 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 1 min                       | Wed Feb 28 17:31:01 1996 PST
     | Wed Feb 28 17:32:01 1996 PST | @ 14 secs ago                 | Wed Feb 28 17:32:15 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 5 hours                     | Thu Feb 29 12:32:01 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Feb 29 15:28:57 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 1 min                       | Thu Feb 29 17:31:01 1996 PST
     | Thu Feb 29 17:32:01 1996 PST | @ 14 secs ago                 | Thu Feb 29 17:32:15 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 5 hours                     | Fri Mar 01 12:32:01 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 1 min                       | Fri Mar 01 17:31:01 1996 PST
     | Fri Mar 01 17:32:01 1996 PST | @ 14 secs ago                 | Fri Mar 01 17:32:15 1996 PST
1788 1789 1790 1791 1792 1793
     | Mon Dec 30 17:32:01 1996 PST | @ 5 mons 12 hours             | Tue Jul 30 05:32:01 1996 PDT
     | Mon Dec 30 17:32:01 1996 PST | @ 5 mons                      | Tue Jul 30 17:32:01 1996 PDT
     | Tue Dec 31 17:32:01 1996 PST | @ 5 mons 12 hours             | Wed Jul 31 05:32:01 1996 PDT
     | Tue Dec 31 17:32:01 1996 PST | @ 5 mons                      | Wed Jul 31 17:32:01 1996 PDT
     | Mon Dec 30 17:32:01 1996 PST | @ 3 mons                      | Mon Sep 30 17:32:01 1996 PDT
     | Tue Dec 31 17:32:01 1996 PST | @ 3 mons                      | Mon Sep 30 17:32:01 1996 PDT
1794 1795 1796 1797 1798 1799 1800 1801 1802 1803
     | Mon Dec 30 17:32:01 1996 PST | @ 10 days                     | Fri Dec 20 17:32:01 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 10 days                     | Sat Dec 21 17:32:01 1996 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 29 15:28:57 1996 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 5 hours                     | Mon Dec 30 12:32:01 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 1 day 2 hours 3 mins 4 secs | Mon Dec 30 15:28:57 1996 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 1 min                       | Mon Dec 30 17:31:01 1996 PST
     | Mon Dec 30 17:32:01 1996 PST | @ 14 secs ago                 | Mon Dec 30 17:32:15 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 5 hours                     | Tue Dec 31 12:32:01 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 1 min                       | Tue Dec 31 17:31:01 1996 PST
     | Tue Dec 31 17:32:01 1996 PST | @ 14 secs ago                 | Tue Dec 31 17:32:15 1996 PST
1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819
     | Fri Dec 31 17:32:01 1999 PST | @ 5 mons 12 hours             | Sat Jul 31 05:32:01 1999 PDT
     | Fri Dec 31 17:32:01 1999 PST | @ 5 mons                      | Sat Jul 31 17:32:01 1999 PDT
     | Sat Jan 01 17:32:01 2000 PST | @ 5 mons 12 hours             | Sun Aug 01 05:32:01 1999 PDT
     | Sat Jan 01 17:32:01 2000 PST | @ 5 mons                      | Sun Aug 01 17:32:01 1999 PDT
     | Fri Dec 31 17:32:01 1999 PST | @ 3 mons                      | Thu Sep 30 17:32:01 1999 PDT
     | Sat Jan 01 17:32:01 2000 PST | @ 3 mons                      | Fri Oct 01 17:32:01 1999 PDT
     | Wed Mar 15 02:14:05 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 14:14:05 1999 PDT
     | Wed Mar 15 03:14:04 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 15:14:04 1999 PDT
     | Wed Mar 15 08:14:01 2000 PST | @ 5 mons 12 hours             | Thu Oct 14 20:14:01 1999 PDT
     | Wed Mar 15 12:14:03 2000 PST | @ 5 mons 12 hours             | Fri Oct 15 00:14:03 1999 PDT
     | Wed Mar 15 13:14:02 2000 PST | @ 5 mons 12 hours             | Fri Oct 15 01:14:02 1999 PDT
     | Wed Mar 15 02:14:05 2000 PST | @ 5 mons                      | Fri Oct 15 02:14:05 1999 PDT
     | Wed Mar 15 03:14:04 2000 PST | @ 5 mons                      | Fri Oct 15 03:14:04 1999 PDT
     | Wed Mar 15 08:14:01 2000 PST | @ 5 mons                      | Fri Oct 15 08:14:01 1999 PDT
     | Wed Mar 15 12:14:03 2000 PST | @ 5 mons                      | Fri Oct 15 12:14:03 1999 PDT
     | Wed Mar 15 13:14:02 2000 PST | @ 5 mons                      | Fri Oct 15 13:14:02 1999 PDT
1820
     | Wed Mar 15 02:14:05 2000 PST | @ 3 mons                      | Wed Dec 15 02:14:05 1999 PST
1821 1822
     | Wed Mar 15 03:14:04 2000 PST | @ 3 mons                      | Wed Dec 15 03:14:04 1999 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 3 mons                      | Wed Dec 15 08:14:01 1999 PST
1823 1824
     | Wed Mar 15 12:14:03 2000 PST | @ 3 mons                      | Wed Dec 15 12:14:03 1999 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 3 mons                      | Wed Dec 15 13:14:02 1999 PST
1825 1826 1827 1828 1829 1830 1831 1832 1833 1834
     | Fri Dec 31 17:32:01 1999 PST | @ 10 days                     | Tue Dec 21 17:32:01 1999 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 10 days                     | Wed Dec 22 17:32:01 1999 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 1 day 2 hours 3 mins 4 secs | Thu Dec 30 15:28:57 1999 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 5 hours                     | Fri Dec 31 12:32:01 1999 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Fri Dec 31 15:28:57 1999 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 1 min                       | Fri Dec 31 17:31:01 1999 PST
     | Fri Dec 31 17:32:01 1999 PST | @ 14 secs ago                 | Fri Dec 31 17:32:15 1999 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 5 hours                     | Sat Jan 01 12:32:01 2000 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 1 min                       | Sat Jan 01 17:31:01 2000 PST
     | Sat Jan 01 17:32:01 2000 PST | @ 14 secs ago                 | Sat Jan 01 17:32:15 2000 PST
1835
     | Wed Mar 15 02:14:05 2000 PST | @ 10 days                     | Sun Mar 05 02:14:05 2000 PST
1836 1837
     | Wed Mar 15 03:14:04 2000 PST | @ 10 days                     | Sun Mar 05 03:14:04 2000 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 10 days                     | Sun Mar 05 08:14:01 2000 PST
1838 1839 1840
     | Wed Mar 15 12:14:03 2000 PST | @ 10 days                     | Sun Mar 05 12:14:03 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 10 days                     | Sun Mar 05 13:14:02 2000 PST
     | Wed Mar 15 02:14:05 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 00:11:01 2000 PST
1841 1842
     | Wed Mar 15 03:14:04 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 01:11:00 2000 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 06:10:57 2000 PST
1843 1844 1845
     | Wed Mar 15 12:14:03 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 10:10:59 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Tue Mar 14 11:10:58 2000 PST
     | Wed Mar 15 02:14:05 2000 PST | @ 5 hours                     | Tue Mar 14 21:14:05 2000 PST
1846
     | Wed Mar 15 03:14:04 2000 PST | @ 5 hours                     | Tue Mar 14 22:14:04 2000 PST
1847 1848
     | Wed Mar 15 02:14:05 2000 PST | @ 1 min                       | Wed Mar 15 02:13:05 2000 PST
     | Wed Mar 15 02:14:05 2000 PST | @ 14 secs ago                 | Wed Mar 15 02:14:19 2000 PST
1849 1850 1851
     | Wed Mar 15 03:14:04 2000 PST | @ 1 min                       | Wed Mar 15 03:13:04 2000 PST
     | Wed Mar 15 08:14:01 2000 PST | @ 5 hours                     | Wed Mar 15 03:14:01 2000 PST
     | Wed Mar 15 03:14:04 2000 PST | @ 14 secs ago                 | Wed Mar 15 03:14:18 2000 PST
1852
     | Wed Mar 15 12:14:03 2000 PST | @ 5 hours                     | Wed Mar 15 07:14:03 2000 PST
1853
     | Wed Mar 15 08:14:01 2000 PST | @ 1 min                       | Wed Mar 15 08:13:01 2000 PST
1854
     | Wed Mar 15 13:14:02 2000 PST | @ 5 hours                     | Wed Mar 15 08:14:02 2000 PST
1855
     | Wed Mar 15 08:14:01 2000 PST | @ 14 secs ago                 | Wed Mar 15 08:14:15 2000 PST
1856 1857 1858 1859
     | Wed Mar 15 12:14:03 2000 PST | @ 1 min                       | Wed Mar 15 12:13:03 2000 PST
     | Wed Mar 15 12:14:03 2000 PST | @ 14 secs ago                 | Wed Mar 15 12:14:17 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 1 min                       | Wed Mar 15 13:13:02 2000 PST
     | Wed Mar 15 13:14:02 2000 PST | @ 14 secs ago                 | Wed Mar 15 13:14:16 2000 PST
1860 1861 1862 1863 1864 1865
     | Sun Dec 31 17:32:01 2000 PST | @ 5 mons 12 hours             | Mon Jul 31 05:32:01 2000 PDT
     | Sun Dec 31 17:32:01 2000 PST | @ 5 mons                      | Mon Jul 31 17:32:01 2000 PDT
     | Mon Jan 01 17:32:01 2001 PST | @ 5 mons 12 hours             | Tue Aug 01 05:32:01 2000 PDT
     | Mon Jan 01 17:32:01 2001 PST | @ 5 mons                      | Tue Aug 01 17:32:01 2000 PDT
     | Sun Dec 31 17:32:01 2000 PST | @ 3 mons                      | Sat Sep 30 17:32:01 2000 PDT
     | Mon Jan 01 17:32:01 2001 PST | @ 3 mons                      | Sun Oct 01 17:32:01 2000 PDT
1866 1867 1868 1869 1870 1871 1872 1873 1874 1875
     | Sun Dec 31 17:32:01 2000 PST | @ 10 days                     | Thu Dec 21 17:32:01 2000 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 10 days                     | Fri Dec 22 17:32:01 2000 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 1 day 2 hours 3 mins 4 secs | Sat Dec 30 15:28:57 2000 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 5 hours                     | Sun Dec 31 12:32:01 2000 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 1 day 2 hours 3 mins 4 secs | Sun Dec 31 15:28:57 2000 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 1 min                       | Sun Dec 31 17:31:01 2000 PST
     | Sun Dec 31 17:32:01 2000 PST | @ 14 secs ago                 | Sun Dec 31 17:32:15 2000 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 5 hours                     | Mon Jan 01 12:32:01 2001 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 1 min                       | Mon Jan 01 17:31:01 2001 PST
     | Mon Jan 01 17:32:01 2001 PST | @ 14 secs ago                 | Mon Jan 01 17:32:15 2001 PST
1876 1877 1878 1879 1880 1881 1882 1883 1884 1885
     | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons 12 hours             | Sun Apr 22 06:19:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 5 mons                      | Sun Apr 22 18:19:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 3 mons                      | Fri Jun 22 18:19:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 10 days                     | Wed Sep 12 18:19:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 1 day 2 hours 3 mins 4 secs | Fri Sep 21 16:16:16 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 5 hours                     | Sat Sep 22 13:19:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 1 min                       | Sat Sep 22 18:18:20 2001 PDT
     | Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago                 | Sat Sep 22 18:19:34 2001 PDT
(160 rows)

1886
SELECT '' AS "16", d.f1 AS "timestamp", timestamp '1980-01-06 00:00 GMT' AS gpstime_zero,
1887 1888
   d.f1 - timestamp '1980-01-06 00:00 GMT' AS difference
  FROM TEMP_TIMESTAMP d
1889
  ORDER BY difference;
1890
 16 |          timestamp           |         gpstime_zero         |             difference              
1891
----+------------------------------+------------------------------+-------------------------------------
1892
    | Thu Jan 01 00:00:00 1970 PST | Sat Jan 05 16:00:00 1980 PST | @ 3656 days 16 hours ago
1893 1894 1895 1896 1897 1898 1899
    | 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
1900
    | Wed Mar 15 02:14:05 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 10 hours 14 mins 5 secs
1901 1902
    | Wed Mar 15 03:14:04 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 11 hours 14 mins 4 secs
    | Wed Mar 15 08:14:01 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 16 hours 14 mins 1 sec
1903 1904
    | Wed Mar 15 12:14:03 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 20 hours 14 mins 3 secs
    | Wed Mar 15 13:14:02 2000 PST | Sat Jan 05 16:00:00 1980 PST | @ 7374 days 21 hours 14 mins 2 secs
1905 1906
    | 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
1907 1908
    | Sat Sep 22 18:19:20 2001 PDT | Sat Jan 05 16:00:00 1980 PST | @ 7931 days 1 hour 19 mins 20 secs
(16 rows)
1909

1910
SELECT '' AS "226", d1.f1 AS timestamp1, d2.f1 AS timestamp2, d1.f1 - d2.f1 AS difference
1911 1912
  FROM TEMP_TIMESTAMP d1, TEMP_TIMESTAMP d2
  ORDER BY timestamp1, timestamp2, difference;
1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931
 226 |          timestamp1          |          timestamp2          |                difference                 
-----+------------------------------+------------------------------+-------------------------------------------
     | Thu Jan 01 00:00:00 1970 PST | Thu Jan 01 00:00:00 1970 PST | @ 0
     | Thu Jan 01 00:00:00 1970 PST | Wed Feb 28 17:32:01 1996 PST | @ 9554 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Thu Feb 29 17:32:01 1996 PST | @ 9555 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Fri Mar 01 17:32:01 1996 PST | @ 9556 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Mon Dec 30 17:32:01 1996 PST | @ 9860 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Tue Dec 31 17:32:01 1996 PST | @ 9861 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Fri Dec 31 17:32:01 1999 PST | @ 10956 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Sat Jan 01 17:32:01 2000 PST | @ 10957 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 02:14:05 2000 PST | @ 11031 days 2 hours 14 mins 5 secs ago
     | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 03:14:04 2000 PST | @ 11031 days 3 hours 14 mins 4 secs ago
     | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 08:14:01 2000 PST | @ 11031 days 8 hours 14 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 12:14:03 2000 PST | @ 11031 days 12 hours 14 mins 3 secs ago
     | Thu Jan 01 00:00:00 1970 PST | Wed Mar 15 13:14:02 2000 PST | @ 11031 days 13 hours 14 mins 2 secs ago
     | Thu Jan 01 00:00:00 1970 PST | Sun Dec 31 17:32:01 2000 PST | @ 11322 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Mon Jan 01 17:32:01 2001 PST | @ 11323 days 17 hours 32 mins 1 sec ago
     | Thu Jan 01 00:00:00 1970 PST | Sat Sep 22 18:19:20 2001 PDT | @ 11587 days 17 hours 19 mins 20 secs ago
     | Wed Feb 28 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9554 days 17 hours 32 mins 1 sec
1932 1933 1934 1935 1936 1937 1938
     | 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
1939
     | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1476 days 8 hours 42 mins 4 secs ago
1940 1941
     | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1476 days 9 hours 42 mins 3 secs ago
     | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1476 days 14 hours 42 mins ago
1942 1943
     | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1476 days 18 hours 42 mins 2 secs ago
     | Wed Feb 28 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1476 days 19 hours 42 mins 1 sec ago
1944 1945
     | 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
1946 1947
     | Wed Feb 28 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2032 days 23 hours 47 mins 19 secs ago
     | Thu Feb 29 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9555 days 17 hours 32 mins 1 sec
1948 1949 1950 1951 1952 1953 1954
     | 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
1955
     | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1475 days 8 hours 42 mins 4 secs ago
1956 1957
     | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1475 days 9 hours 42 mins 3 secs ago
     | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1475 days 14 hours 42 mins ago
1958 1959
     | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1475 days 18 hours 42 mins 2 secs ago
     | Thu Feb 29 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1475 days 19 hours 42 mins 1 sec ago
1960 1961
     | 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
1962 1963
     | Thu Feb 29 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2031 days 23 hours 47 mins 19 secs ago
     | Fri Mar 01 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9556 days 17 hours 32 mins 1 sec
1964 1965 1966 1967 1968 1969 1970
     | 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
1971
     | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1474 days 8 hours 42 mins 4 secs ago
1972 1973
     | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1474 days 9 hours 42 mins 3 secs ago
     | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1474 days 14 hours 42 mins ago
1974 1975
     | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1474 days 18 hours 42 mins 2 secs ago
     | Fri Mar 01 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1474 days 19 hours 42 mins 1 sec ago
1976 1977
     | 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
1978 1979
     | Fri Mar 01 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 2030 days 23 hours 47 mins 19 secs ago
     | Mon Dec 30 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9860 days 17 hours 32 mins 1 sec
1980 1981 1982 1983 1984 1985 1986
     | 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
1987
     | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1170 days 8 hours 42 mins 4 secs ago
1988 1989
     | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1170 days 9 hours 42 mins 3 secs ago
     | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1170 days 14 hours 42 mins ago
1990 1991
     | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1170 days 18 hours 42 mins 2 secs ago
     | Mon Dec 30 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1170 days 19 hours 42 mins 1 sec ago
1992 1993
     | 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
1994 1995
     | Mon Dec 30 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 1726 days 23 hours 47 mins 19 secs ago
     | Tue Dec 31 17:32:01 1996 PST | Thu Jan 01 00:00:00 1970 PST | @ 9861 days 17 hours 32 mins 1 sec
1996 1997 1998 1999 2000 2001 2002
     | 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
2003
     | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 02:14:05 2000 PST | @ 1169 days 8 hours 42 mins 4 secs ago
2004 2005
     | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 03:14:04 2000 PST | @ 1169 days 9 hours 42 mins 3 secs ago
     | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 08:14:01 2000 PST | @ 1169 days 14 hours 42 mins ago
2006 2007
     | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 12:14:03 2000 PST | @ 1169 days 18 hours 42 mins 2 secs ago
     | Tue Dec 31 17:32:01 1996 PST | Wed Mar 15 13:14:02 2000 PST | @ 1169 days 19 hours 42 mins 1 sec ago
2008 2009
     | 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
2010 2011
     | Tue Dec 31 17:32:01 1996 PST | Sat Sep 22 18:19:20 2001 PDT | @ 1725 days 23 hours 47 mins 19 secs ago
     | Fri Dec 31 17:32:01 1999 PST | Thu Jan 01 00:00:00 1970 PST | @ 10956 days 17 hours 32 mins 1 sec
2012 2013 2014 2015 2016 2017 2018
     | 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
2019
     | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 02:14:05 2000 PST | @ 74 days 8 hours 42 mins 4 secs ago
2020 2021
     | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 03:14:04 2000 PST | @ 74 days 9 hours 42 mins 3 secs ago
     | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 08:14:01 2000 PST | @ 74 days 14 hours 42 mins ago
2022 2023
     | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 12:14:03 2000 PST | @ 74 days 18 hours 42 mins 2 secs ago
     | Fri Dec 31 17:32:01 1999 PST | Wed Mar 15 13:14:02 2000 PST | @ 74 days 19 hours 42 mins 1 sec ago
2024 2025
     | 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
2026 2027
     | Fri Dec 31 17:32:01 1999 PST | Sat Sep 22 18:19:20 2001 PDT | @ 630 days 23 hours 47 mins 19 secs ago
     | Sat Jan 01 17:32:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 10957 days 17 hours 32 mins 1 sec
2028 2029 2030 2031 2032 2033 2034
     | 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
2035
     | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 73 days 8 hours 42 mins 4 secs ago
2036 2037
     | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 73 days 9 hours 42 mins 3 secs ago
     | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 73 days 14 hours 42 mins ago
2038 2039
     | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 73 days 18 hours 42 mins 2 secs ago
     | Sat Jan 01 17:32:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 73 days 19 hours 42 mins 1 sec ago
2040 2041
     | 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
2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059
     | Sat Jan 01 17:32:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 629 days 23 hours 47 mins 19 secs ago
     | Wed Mar 15 02:14:05 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 2 hours 14 mins 5 secs
     | Wed Mar 15 02:14:05 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 8 hours 42 mins 4 secs
     | Wed Mar 15 02:14:05 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 8 hours 42 mins 4 secs
     | Wed Mar 15 02:14:05 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 8 hours 42 mins 4 secs
     | Wed Mar 15 02:14:05 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 8 hours 42 mins 4 secs
     | Wed Mar 15 02:14:05 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 8 hours 42 mins 4 secs
     | Wed Mar 15 02:14:05 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 8 hours 42 mins 4 secs
     | Wed Mar 15 02:14:05 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 8 hours 42 mins 4 secs
     | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 0
     | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 59 mins 59 secs ago
     | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 5 hours 59 mins 56 secs ago
     | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 9 hours 59 mins 58 secs ago
     | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 10 hours 59 mins 57 secs ago
     | Wed Mar 15 02:14:05 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 15 hours 17 mins 56 secs ago
     | Wed Mar 15 02:14:05 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 15 hours 17 mins 56 secs ago
     | Wed Mar 15 02:14:05 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 15 hours 5 mins 15 secs ago
     | Wed Mar 15 03:14:04 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 3 hours 14 mins 4 secs
2060 2061 2062 2063 2064 2065 2066
     | Wed Mar 15 03:14:04 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 9 hours 42 mins 3 secs
     | Wed Mar 15 03:14:04 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 9 hours 42 mins 3 secs
     | Wed Mar 15 03:14:04 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 9 hours 42 mins 3 secs
     | Wed Mar 15 03:14:04 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 9 hours 42 mins 3 secs
     | Wed Mar 15 03:14:04 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 9 hours 42 mins 3 secs
     | Wed Mar 15 03:14:04 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 9 hours 42 mins 3 secs
     | Wed Mar 15 03:14:04 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 9 hours 42 mins 3 secs
2067
     | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 59 mins 59 secs
2068 2069
     | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 0
     | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 4 hours 59 mins 57 secs ago
2070 2071
     | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 8 hours 59 mins 59 secs ago
     | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 9 hours 59 mins 58 secs ago
2072 2073
     | Wed Mar 15 03:14:04 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 14 hours 17 mins 57 secs ago
     | Wed Mar 15 03:14:04 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 14 hours 17 mins 57 secs ago
2074 2075
     | Wed Mar 15 03:14:04 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 14 hours 5 mins 16 secs ago
     | Wed Mar 15 08:14:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 8 hours 14 mins 1 sec
2076 2077 2078 2079 2080 2081 2082
     | Wed Mar 15 08:14:01 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 14 hours 42 mins
     | Wed Mar 15 08:14:01 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 14 hours 42 mins
     | Wed Mar 15 08:14:01 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 14 hours 42 mins
     | Wed Mar 15 08:14:01 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 14 hours 42 mins
     | Wed Mar 15 08:14:01 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 14 hours 42 mins
     | Wed Mar 15 08:14:01 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 14 hours 42 mins
     | Wed Mar 15 08:14:01 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 14 hours 42 mins
2083
     | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 5 hours 59 mins 56 secs
2084 2085
     | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 4 hours 59 mins 57 secs
     | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 0
2086 2087
     | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 4 hours 2 secs ago
     | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 5 hours 1 sec ago
2088 2089
     | Wed Mar 15 08:14:01 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 9 hours 18 mins ago
     | Wed Mar 15 08:14:01 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 9 hours 18 mins ago
2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123
     | Wed Mar 15 08:14:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 9 hours 5 mins 19 secs ago
     | Wed Mar 15 12:14:03 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 12 hours 14 mins 3 secs
     | Wed Mar 15 12:14:03 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 18 hours 42 mins 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 18 hours 42 mins 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 18 hours 42 mins 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 18 hours 42 mins 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 18 hours 42 mins 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 18 hours 42 mins 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 18 hours 42 mins 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 9 hours 59 mins 58 secs
     | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 8 hours 59 mins 59 secs
     | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 4 hours 2 secs
     | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 0
     | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 59 mins 59 secs ago
     | Wed Mar 15 12:14:03 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 5 hours 17 mins 58 secs ago
     | Wed Mar 15 12:14:03 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 5 hours 17 mins 58 secs ago
     | Wed Mar 15 12:14:03 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 5 hours 5 mins 17 secs ago
     | Wed Mar 15 13:14:02 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11031 days 13 hours 14 mins 2 secs
     | Wed Mar 15 13:14:02 2000 PST | Wed Feb 28 17:32:01 1996 PST | @ 1476 days 19 hours 42 mins 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Thu Feb 29 17:32:01 1996 PST | @ 1475 days 19 hours 42 mins 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Fri Mar 01 17:32:01 1996 PST | @ 1474 days 19 hours 42 mins 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Mon Dec 30 17:32:01 1996 PST | @ 1170 days 19 hours 42 mins 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Tue Dec 31 17:32:01 1996 PST | @ 1169 days 19 hours 42 mins 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Fri Dec 31 17:32:01 1999 PST | @ 74 days 19 hours 42 mins 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Sat Jan 01 17:32:01 2000 PST | @ 73 days 19 hours 42 mins 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 10 hours 59 mins 57 secs
     | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 9 hours 59 mins 58 secs
     | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 5 hours 1 sec
     | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 59 mins 59 secs
     | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 0
     | Wed Mar 15 13:14:02 2000 PST | Sun Dec 31 17:32:01 2000 PST | @ 291 days 4 hours 17 mins 59 secs ago
     | Wed Mar 15 13:14:02 2000 PST | Mon Jan 01 17:32:01 2001 PST | @ 292 days 4 hours 17 mins 59 secs ago
     | Wed Mar 15 13:14:02 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 556 days 4 hours 5 mins 18 secs ago
     | Sun Dec 31 17:32:01 2000 PST | Thu Jan 01 00:00:00 1970 PST | @ 11322 days 17 hours 32 mins 1 sec
2124 2125 2126 2127 2128 2129 2130
     | 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
2131
     | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 02:14:05 2000 PST | @ 291 days 15 hours 17 mins 56 secs
2132 2133
     | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 03:14:04 2000 PST | @ 291 days 14 hours 17 mins 57 secs
     | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 08:14:01 2000 PST | @ 291 days 9 hours 18 mins
2134 2135
     | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 12:14:03 2000 PST | @ 291 days 5 hours 17 mins 58 secs
     | Sun Dec 31 17:32:01 2000 PST | Wed Mar 15 13:14:02 2000 PST | @ 291 days 4 hours 17 mins 59 secs
2136 2137
     | 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
2138 2139
     | Sun Dec 31 17:32:01 2000 PST | Sat Sep 22 18:19:20 2001 PDT | @ 264 days 23 hours 47 mins 19 secs ago
     | Mon Jan 01 17:32:01 2001 PST | Thu Jan 01 00:00:00 1970 PST | @ 11323 days 17 hours 32 mins 1 sec
2140 2141 2142 2143 2144 2145 2146
     | 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
2147
     | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 02:14:05 2000 PST | @ 292 days 15 hours 17 mins 56 secs
2148 2149
     | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 03:14:04 2000 PST | @ 292 days 14 hours 17 mins 57 secs
     | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 08:14:01 2000 PST | @ 292 days 9 hours 18 mins
2150 2151
     | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 12:14:03 2000 PST | @ 292 days 5 hours 17 mins 58 secs
     | Mon Jan 01 17:32:01 2001 PST | Wed Mar 15 13:14:02 2000 PST | @ 292 days 4 hours 17 mins 59 secs
2152 2153
     | 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
2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172
     | Mon Jan 01 17:32:01 2001 PST | Sat Sep 22 18:19:20 2001 PDT | @ 263 days 23 hours 47 mins 19 secs ago
     | Sat Sep 22 18:19:20 2001 PDT | Thu Jan 01 00:00:00 1970 PST | @ 11587 days 17 hours 19 mins 20 secs
     | Sat Sep 22 18:19:20 2001 PDT | Wed Feb 28 17:32:01 1996 PST | @ 2032 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Thu Feb 29 17:32:01 1996 PST | @ 2031 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Fri Mar 01 17:32:01 1996 PST | @ 2030 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Mon Dec 30 17:32:01 1996 PST | @ 1726 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Tue Dec 31 17:32:01 1996 PST | @ 1725 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Fri Dec 31 17:32:01 1999 PST | @ 630 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Sat Jan 01 17:32:01 2000 PST | @ 629 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 02:14:05 2000 PST | @ 556 days 15 hours 5 mins 15 secs
     | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 03:14:04 2000 PST | @ 556 days 14 hours 5 mins 16 secs
     | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 08:14:01 2000 PST | @ 556 days 9 hours 5 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 12:14:03 2000 PST | @ 556 days 5 hours 5 mins 17 secs
     | Sat Sep 22 18:19:20 2001 PDT | Wed Mar 15 13:14:02 2000 PST | @ 556 days 4 hours 5 mins 18 secs
     | Sat Sep 22 18:19:20 2001 PDT | Sun Dec 31 17:32:01 2000 PST | @ 264 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Mon Jan 01 17:32:01 2001 PST | @ 263 days 23 hours 47 mins 19 secs
     | Sat Sep 22 18:19:20 2001 PDT | Sat Sep 22 18:19:20 2001 PDT | @ 0
(256 rows)

2173 2174 2175
--
-- abstime, reltime arithmetic
--
2176
SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime
2177
   WHERE (ABSTIME_TBL.f1 + RELTIME_TBL.f1) < abstime 'Jan 14 14:00:00 1971'
2178 2179 2180 2181 2182 2183 2184 2185
   ORDER BY abstime, reltime;
 ten |           abstime            |    reltime    
-----+------------------------------+---------------
     | Sat May 10 23:59:12 1947 PST | @ 14 secs ago
     | Sat May 10 23:59:12 1947 PST | @ 1 min
     | Sat May 10 23:59:12 1947 PST | @ 5 hours
     | Sat May 10 23:59:12 1947 PST | @ 10 days
     | Sat May 10 23:59:12 1947 PST | @ 3 mons
2186 2187 2188 2189 2190
     | Wed Dec 31 16:00:00 1969 PST | @ 14 secs ago
     | Wed Dec 31 16:00:00 1969 PST | @ 1 min
     | Wed Dec 31 16:00:00 1969 PST | @ 5 hours
     | Wed Dec 31 16:00:00 1969 PST | @ 10 days
     | Wed Dec 31 16:00:00 1969 PST | @ 3 mons
2191 2192 2193 2194 2195 2196 2197
(10 rows)

-- these four queries should return the same answer
-- the "infinity" and "-infinity" tuples in ABSTIME_TBL cannot be added and
-- therefore, should not show up in the results.
SELECT '' AS three, ABSTIME_TBL.*
  WHERE  (ABSTIME_TBL.f1 + reltime '@ 3 year')         -- +3 years
2198
    < abstime 'Jan 14 14:00:00 1977';
2199 2200 2201
 three |              f1              
-------+------------------------------
       | Sun Jan 14 03:14:21 1973 PST
2202
       | Wed Dec 31 16:00:00 1969 PST
2203 2204 2205 2206 2207
       | Sat May 10 23:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 + reltime '@ 3 year ago')    -- -3 years
2208
     < abstime 'Jan 14 14:00:00 1971';
2209 2210 2211
 three |              f1              
-------+------------------------------
       | Sun Jan 14 03:14:21 1973 PST
2212
       | Wed Dec 31 16:00:00 1969 PST
2213 2214 2215 2216 2217
       | Sat May 10 23:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 - reltime '@ 3 year')        -- -(+3) years
2218
    < abstime 'Jan 14 14:00:00 1971';
2219 2220 2221
 three |              f1              
-------+------------------------------
       | Sun Jan 14 03:14:21 1973 PST
2222
       | Wed Dec 31 16:00:00 1969 PST
2223 2224 2225 2226 2227
       | Sat May 10 23:59:12 1947 PST
(3 rows)

SELECT '' AS three, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 - reltime '@ 3 year ago')    -- -(-3) years
2228
     < abstime 'Jan 14 14:00:00 1977';
2229 2230 2231
 three |              f1              
-------+------------------------------
       | Sun Jan 14 03:14:21 1973 PST
2232
       | Wed Dec 31 16:00:00 1969 PST
2233 2234
       | Sat May 10 23:59:12 1947 PST
(3 rows)
2235 2236

--
2237
-- Conversions
2238
--
2239
SELECT '' AS "16", f1 AS "timestamp", date(f1) AS date
2240
  FROM TEMP_TIMESTAMP
2241
  WHERE f1 <> timestamp 'now'
2242
  ORDER BY date, "timestamp";
2243
 16 |          timestamp           |    date    
2244
----+------------------------------+------------
2245
    | Thu Jan 01 00:00:00 1970 PST | 01-01-1970
2246 2247 2248 2249 2250 2251 2252
    | 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
2253
    | Wed Mar 15 02:14:05 2000 PST | 03-15-2000
2254 2255
    | Wed Mar 15 03:14:04 2000 PST | 03-15-2000
    | Wed Mar 15 08:14:01 2000 PST | 03-15-2000
2256 2257
    | Wed Mar 15 12:14:03 2000 PST | 03-15-2000
    | Wed Mar 15 13:14:02 2000 PST | 03-15-2000
2258 2259
    | Sun Dec 31 17:32:01 2000 PST | 12-31-2000
    | Mon Jan 01 17:32:01 2001 PST | 01-01-2001
2260 2261
    | Sat Sep 22 18:19:20 2001 PDT | 09-22-2001
(16 rows)
2262

2263
SELECT '' AS "16", f1 AS "timestamp", abstime(f1) AS abstime
2264
  FROM TEMP_TIMESTAMP
2265
  ORDER BY abstime;
2266
 16 |          timestamp           |           abstime            
2267
----+------------------------------+------------------------------
2268
    | Thu Jan 01 00:00:00 1970 PST | Thu Jan 01 00:00:00 1970 PST
2269 2270 2271 2272 2273 2274 2275
    | 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
2276
    | Wed Mar 15 02:14:05 2000 PST | Wed Mar 15 02:14:05 2000 PST
2277 2278
    | Wed Mar 15 03:14:04 2000 PST | Wed Mar 15 03:14:04 2000 PST
    | Wed Mar 15 08:14:01 2000 PST | Wed Mar 15 08:14:01 2000 PST
2279 2280
    | Wed Mar 15 12:14:03 2000 PST | Wed Mar 15 12:14:03 2000 PST
    | Wed Mar 15 13:14:02 2000 PST | Wed Mar 15 13:14:02 2000 PST
2281 2282
    | 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
2283 2284
    | Sat Sep 22 18:19:20 2001 PDT | Sat Sep 22 18:19:20 2001 PDT
(16 rows)
2285

2286
SELECT '' AS four, f1 AS abstime, date(f1) AS date
2287
  FROM ABSTIME_TBL
2288
  WHERE isfinite(f1) AND f1 <> abstime 'now'
2289
  ORDER BY date, abstime;
2290
 four |           abstime            |    date    
2291 2292
------+------------------------------+------------
      | Sat May 10 23:59:12 1947 PST | 05-10-1947
2293
      | Wed Dec 31 16:00:00 1969 PST | 12-31-1969
2294 2295 2296 2297
      | Sun Jan 14 03:14:21 1973 PST | 01-14-1973
      | Mon May 01 00:30:30 1995 PDT | 05-01-1995
(4 rows)

2298
SELECT '' AS two, d1 AS "timestamp", abstime(d1) AS abstime
2299
  FROM TIMESTAMP_TBL WHERE NOT isfinite(d1);
2300 2301 2302 2303 2304
 two | timestamp |  abstime  
-----+-----------+-----------
     | -infinity | -infinity
     | infinity  | infinity
(2 rows)
2305

2306
SELECT '' AS three, f1 as abstime, cast(f1 as timestamp) AS "timestamp"
2307
  FROM ABSTIME_TBL WHERE NOT isfinite(f1);
2308
ERROR:  Unable to convert abstime 'invalid' to timestamptz
2309
SELECT '' AS ten, f1 AS interval, reltime(f1) AS reltime
2310 2311
  FROM INTERVAL_TBL;
 ten |           interval            |            reltime            
2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324
-----+-------------------------------+-------------------------------
     | @ 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)

Tom Lane's avatar
Tom Lane committed
2325
SELECT '' AS six, f1 as reltime, CAST(f1 AS interval) AS interval
2326
  FROM RELTIME_TBL;
2327
 six |    reltime    |   interval    
2328 2329 2330 2331 2332 2333 2334 2335 2336
-----+---------------+---------------
     | @ 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)

2337
DROP TABLE TEMP_TIMESTAMP;
2338
--
2339
-- Formats
2340 2341 2342
--
SET DateStyle TO 'US,Postgres';
SHOW DateStyle;
2343
INFO:  DateStyle is Postgres with US (NonEuropean) conventions
2344 2345 2346
SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL;
 64 |         us_postgres         
----+-----------------------------
2347 2348
    | -infinity
    | infinity
2349 2350
    | Thu Jan 01 00:00:00 1970
    | Mon Feb 10 17:32:01 1997
2351 2352
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:02 1997
2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380 2381 2382 2383 2384 2385 2386 2387
    | Mon Feb 10 17:32:01.40 1997
    | Mon Feb 10 17:32:01.50 1997
    | Mon Feb 10 17:32:01.60 1997
    | Thu Jan 02 00:00:00 1997
    | Thu Jan 02 03:04:05 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Tue Jun 10 17:32:01 1997
    | Sat Sep 22 18:19:20 2001
    | Wed Mar 15 08:14:01 2000
    | Wed Mar 15 13:14:02 2000
    | Wed Mar 15 12:14:03 2000
    | Wed Mar 15 03:14:04 2000
    | Wed Mar 15 02:14:05 2000
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:00 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Tue Jun 10 18:32:01 1997
    | Mon Feb 10 17:32:01 1997
    | Tue Feb 11 17:32:01 1997
    | Wed Feb 12 17:32:01 1997
    | Thu Feb 13 17:32:01 1997
    | Fri Feb 14 17:32:01 1997
    | Sat Feb 15 17:32:01 1997
    | Sun Feb 16 17:32:01 1997
2388 2389 2390 2391 2392 2393 2394
    | 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
2395
    | Sun Feb 16 17:32:01 1997
2396
    | Sat Feb 16 17:32:01 2097
2397 2398 2399 2400 2401 2402 2403 2404 2405 2406 2407 2408 2409 2410 2411 2412 2413 2414
    | Wed Feb 28 17:32:01 1996
    | Thu Feb 29 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
    | Wed Jan 01 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
    | Fri Dec 31 17:32:01 1999
    | Sat Jan 01 17:32:01 2000
    | Sun Dec 31 17:32:01 2000
    | Mon Jan 01 17:32:01 2001
(64 rows)

SELECT '' AS seven, f1 AS us_postgres FROM ABSTIME_TBL;
 seven |         us_postgres          
2415 2416 2417
-------+------------------------------
       | Sun Jan 14 03:14:21 1973 PST
       | Mon May 01 00:30:30 1995 PDT
2418
       | Wed Dec 31 16:00:00 1969 PST
2419 2420 2421 2422
       | infinity
       | -infinity
       | Sat May 10 23:59:12 1947 PST
       | invalid
2423
(7 rows)
2424 2425

SET DateStyle TO 'US,ISO';
2426 2427 2428
SELECT '' AS "64", d1 AS us_iso FROM TIMESTAMP_TBL;
 64 |         us_iso         
----+------------------------
2429 2430
    | -infinity
    | infinity
2431 2432
    | 1970-01-01 00:00:00
    | 1997-02-10 17:32:01
2433 2434
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:02
2435 2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469
    | 1997-02-10 17:32:01.40
    | 1997-02-10 17:32:01.50
    | 1997-02-10 17:32:01.60
    | 1997-01-02 00:00:00
    | 1997-01-02 03:04:05
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-06-10 17:32:01
    | 2001-09-22 18:19:20
    | 2000-03-15 08:14:01
    | 2000-03-15 13:14:02
    | 2000-03-15 12:14:03
    | 2000-03-15 03:14:04
    | 2000-03-15 02:14:05
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:00
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-06-10 18:32:01
    | 1997-02-10 17:32:01
    | 1997-02-11 17:32:01
    | 1997-02-12 17:32:01
    | 1997-02-13 17:32:01
    | 1997-02-14 17:32:01
    | 1997-02-15 17:32:01
    | 1997-02-16 17:32:01
2470 2471 2472 2473 2474 2475 2476
    | 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
2477
    | 1997-02-16 17:32:01
2478
    | 2097-02-16 17:32:01
2479 2480 2481 2482 2483 2484 2485 2486 2487 2488 2489 2490 2491 2492 2493 2494 2495 2496
    | 1996-02-28 17:32:01
    | 1996-02-29 17:32:01
    | 1996-03-01 17:32:01
    | 1996-12-30 17:32:01
    | 1996-12-31 17:32:01
    | 1997-01-01 17:32:01
    | 1997-02-28 17:32:01
    | 1997-03-01 17:32:01
    | 1997-12-30 17:32:01
    | 1997-12-31 17:32:01
    | 1999-12-31 17:32:01
    | 2000-01-01 17:32:01
    | 2000-12-31 17:32:01
    | 2001-01-01 17:32:01
(64 rows)

SELECT '' AS seven, f1 AS us_iso FROM ABSTIME_TBL;
 seven |         us_iso         
2497 2498 2499
-------+------------------------
       | 1973-01-14 03:14:21-08
       | 1995-05-01 00:30:30-07
2500
       | 1969-12-31 16:00:00-08
2501 2502 2503 2504
       | infinity
       | -infinity
       | 1947-05-10 23:59:12-08
       | invalid
2505
(7 rows)
2506 2507 2508

SET DateStyle TO 'US,SQL';
SHOW DateStyle;
2509
INFO:  DateStyle is SQL with US (NonEuropean) conventions
2510 2511 2512
SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL;
 64 |         us_sql         
----+------------------------
2513 2514
    | -infinity
    | infinity
2515 2516 2517 2518
    | 01/01/1970 00:00:00
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:02
2519 2520 2521
    | 02/10/1997 17:32:01.40
    | 02/10/1997 17:32:01.50
    | 02/10/1997 17:32:01.60
2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553
    | 01/02/1997 00:00:00
    | 01/02/1997 03:04:05
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 06/10/1997 17:32:01
    | 09/22/2001 18:19:20
    | 03/15/2000 08:14:01
    | 03/15/2000 13:14:02
    | 03/15/2000 12:14:03
    | 03/15/2000 03:14:04
    | 03/15/2000 02:14:05
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:00
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 02/10/1997 17:32:01
    | 06/10/1997 18:32:01
    | 02/10/1997 17:32:01
    | 02/11/1997 17:32:01
    | 02/12/1997 17:32:01
    | 02/13/1997 17:32:01
    | 02/14/1997 17:32:01
    | 02/15/1997 17:32:01
    | 02/16/1997 17:32:01
2554
    | 02/16/0097 17:32 BC
2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576
    | 02/16/0097 17:32:01
    | 02/16/0597 17:32:01
    | 02/16/1097 17:32:01
    | 02/16/1697 17:32:01
    | 02/16/1797 17:32:01
    | 02/16/1897 17:32:01
    | 02/16/1997 17:32:01
    | 02/16/2097 17:32:01
    | 02/28/1996 17:32:01
    | 02/29/1996 17:32:01
    | 03/01/1996 17:32:01
    | 12/30/1996 17:32:01
    | 12/31/1996 17:32:01
    | 01/01/1997 17:32:01
    | 02/28/1997 17:32:01
    | 03/01/1997 17:32:01
    | 12/30/1997 17:32:01
    | 12/31/1997 17:32:01
    | 12/31/1999 17:32:01
    | 01/01/2000 17:32:01
    | 12/31/2000 17:32:01
    | 01/01/2001 17:32:01
2577 2578 2579
(64 rows)

SELECT '' AS seven, f1 AS us_sql FROM ABSTIME_TBL;
2580 2581 2582 2583 2584
 seven |         us_sql          
-------+-------------------------
       | 01/14/1973 03:14:21 PST
       | 05/01/1995 00:30:30 PDT
       | 12/31/1969 16:00:00 PST
2585 2586
       | infinity
       | -infinity
2587
       | 05/10/1947 23:59:12 PST
2588
       | invalid
2589
(7 rows)
2590 2591 2592

SET DateStyle TO 'European,Postgres';
SHOW DateStyle;
2593
INFO:  DateStyle is Postgres with European conventions
2594 2595
INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957');
SELECT count(*) as one FROM TIMESTAMP_TBL WHERE d1 = 'Jun 13 1957';
2596 2597
 one 
-----
2598
   1
2599 2600
(1 row)

2601 2602 2603
SELECT '' AS "65", d1 AS european_postgres FROM TIMESTAMP_TBL;
 65 |      european_postgres      
----+-----------------------------
2604 2605
    | -infinity
    | infinity
2606 2607
    | Thu 01 Jan 00:00:00 1970
    | Mon 10 Feb 17:32:01 1997
2608 2609
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:02 1997
2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644
    | Mon 10 Feb 17:32:01.40 1997
    | Mon 10 Feb 17:32:01.50 1997
    | Mon 10 Feb 17:32:01.60 1997
    | Thu 02 Jan 00:00:00 1997
    | Thu 02 Jan 03:04:05 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Tue 10 Jun 17:32:01 1997
    | Sat 22 Sep 18:19:20 2001
    | Wed 15 Mar 08:14:01 2000
    | Wed 15 Mar 13:14:02 2000
    | Wed 15 Mar 12:14:03 2000
    | Wed 15 Mar 03:14:04 2000
    | Wed 15 Mar 02:14:05 2000
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:00 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Tue 10 Jun 18:32:01 1997
    | Mon 10 Feb 17:32:01 1997
    | Tue 11 Feb 17:32:01 1997
    | Wed 12 Feb 17:32:01 1997
    | Thu 13 Feb 17:32:01 1997
    | Fri 14 Feb 17:32:01 1997
    | Sat 15 Feb 17:32:01 1997
    | Sun 16 Feb 17:32:01 1997
2645 2646 2647 2648 2649 2650 2651
    | Tue 16 Feb 17:32 0097 BC
    | Sat 16 Feb 17:32:01 0097
    | Thu 16 Feb 17:32:01 0597
    | Tue 16 Feb 17:32:01 1097
    | Sat 16 Feb 17:32:01 1697
    | Thu 16 Feb 17:32:01 1797
    | Tue 16 Feb 17:32:01 1897
2652
    | Sun 16 Feb 17:32:01 1997
2653
    | Sat 16 Feb 17:32:01 2097
2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672
    | Wed 28 Feb 17:32:01 1996
    | Thu 29 Feb 17:32:01 1996
    | Fri 01 Mar 17:32:01 1996
    | Mon 30 Dec 17:32:01 1996
    | Tue 31 Dec 17:32:01 1996
    | Wed 01 Jan 17:32:01 1997
    | Fri 28 Feb 17:32:01 1997
    | Sat 01 Mar 17:32:01 1997
    | Tue 30 Dec 17:32:01 1997
    | Wed 31 Dec 17:32:01 1997
    | Fri 31 Dec 17:32:01 1999
    | Sat 01 Jan 17:32:01 2000
    | Sun 31 Dec 17:32:01 2000
    | Mon 01 Jan 17:32:01 2001
    | Thu 13 Jun 00:00:00 1957
(65 rows)

SELECT '' AS seven, f1 AS european_postgres FROM ABSTIME_TBL;
 seven |      european_postgres       
2673 2674 2675
-------+------------------------------
       | Sun 14 Jan 03:14:21 1973 PST
       | Mon 01 May 00:30:30 1995 PDT
2676
       | Wed 31 Dec 16:00:00 1969 PST
2677 2678 2679 2680
       | infinity
       | -infinity
       | Sat 10 May 23:59:12 1947 PST
       | invalid
2681
(7 rows)
2682 2683 2684

SET DateStyle TO 'European,ISO';
SHOW DateStyle;
2685
INFO:  DateStyle is ISO with European conventions
2686 2687 2688
SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL;
 65 |      european_iso      
----+------------------------
2689 2690
    | -infinity
    | infinity
2691 2692
    | 1970-01-01 00:00:00
    | 1997-02-10 17:32:01
2693 2694
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:02
2695 2696 2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729
    | 1997-02-10 17:32:01.40
    | 1997-02-10 17:32:01.50
    | 1997-02-10 17:32:01.60
    | 1997-01-02 00:00:00
    | 1997-01-02 03:04:05
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-06-10 17:32:01
    | 2001-09-22 18:19:20
    | 2000-03-15 08:14:01
    | 2000-03-15 13:14:02
    | 2000-03-15 12:14:03
    | 2000-03-15 03:14:04
    | 2000-03-15 02:14:05
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:00
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-02-10 17:32:01
    | 1997-06-10 18:32:01
    | 1997-02-10 17:32:01
    | 1997-02-11 17:32:01
    | 1997-02-12 17:32:01
    | 1997-02-13 17:32:01
    | 1997-02-14 17:32:01
    | 1997-02-15 17:32:01
    | 1997-02-16 17:32:01
2730 2731 2732 2733 2734 2735 2736
    | 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
2737
    | 1997-02-16 17:32:01
2738
    | 2097-02-16 17:32:01
2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750 2751 2752 2753 2754 2755 2756 2757
    | 1996-02-28 17:32:01
    | 1996-02-29 17:32:01
    | 1996-03-01 17:32:01
    | 1996-12-30 17:32:01
    | 1996-12-31 17:32:01
    | 1997-01-01 17:32:01
    | 1997-02-28 17:32:01
    | 1997-03-01 17:32:01
    | 1997-12-30 17:32:01
    | 1997-12-31 17:32:01
    | 1999-12-31 17:32:01
    | 2000-01-01 17:32:01
    | 2000-12-31 17:32:01
    | 2001-01-01 17:32:01
    | 1957-06-13 00:00:00
(65 rows)

SELECT '' AS seven, f1 AS european_iso FROM ABSTIME_TBL;
 seven |      european_iso      
2758 2759 2760
-------+------------------------
       | 1973-01-14 03:14:21-08
       | 1995-05-01 00:30:30-07
2761
       | 1969-12-31 16:00:00-08
2762 2763 2764 2765
       | infinity
       | -infinity
       | 1947-05-10 23:59:12-08
       | invalid
2766
(7 rows)
2767 2768 2769

SET DateStyle TO 'European,SQL';
SHOW DateStyle;
2770
INFO:  DateStyle is SQL with European conventions
2771 2772 2773
SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL;
 65 |      european_sql      
----+------------------------
2774 2775
    | -infinity
    | infinity
2776 2777 2778 2779
    | 01/01/1970 00:00:00
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:02
2780 2781 2782
    | 10/02/1997 17:32:01.40
    | 10/02/1997 17:32:01.50
    | 10/02/1997 17:32:01.60
2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814
    | 02/01/1997 00:00:00
    | 02/01/1997 03:04:05
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/06/1997 17:32:01
    | 22/09/2001 18:19:20
    | 15/03/2000 08:14:01
    | 15/03/2000 13:14:02
    | 15/03/2000 12:14:03
    | 15/03/2000 03:14:04
    | 15/03/2000 02:14:05
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:00
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/02/1997 17:32:01
    | 10/06/1997 18:32:01
    | 10/02/1997 17:32:01
    | 11/02/1997 17:32:01
    | 12/02/1997 17:32:01
    | 13/02/1997 17:32:01
    | 14/02/1997 17:32:01
    | 15/02/1997 17:32:01
    | 16/02/1997 17:32:01
2815
    | 16/02/0097 17:32 BC
2816 2817 2818 2819 2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838
    | 16/02/0097 17:32:01
    | 16/02/0597 17:32:01
    | 16/02/1097 17:32:01
    | 16/02/1697 17:32:01
    | 16/02/1797 17:32:01
    | 16/02/1897 17:32:01
    | 16/02/1997 17:32:01
    | 16/02/2097 17:32:01
    | 28/02/1996 17:32:01
    | 29/02/1996 17:32:01
    | 01/03/1996 17:32:01
    | 30/12/1996 17:32:01
    | 31/12/1996 17:32:01
    | 01/01/1997 17:32:01
    | 28/02/1997 17:32:01
    | 01/03/1997 17:32:01
    | 30/12/1997 17:32:01
    | 31/12/1997 17:32:01
    | 31/12/1999 17:32:01
    | 01/01/2000 17:32:01
    | 31/12/2000 17:32:01
    | 01/01/2001 17:32:01
    | 13/06/1957 00:00:00
2839 2840 2841
(65 rows)

SELECT '' AS seven, f1 AS european_sql FROM ABSTIME_TBL;
2842 2843 2844 2845 2846
 seven |      european_sql       
-------+-------------------------
       | 14/01/1973 03:14:21 PST
       | 01/05/1995 00:30:30 PDT
       | 31/12/1969 16:00:00 PST
2847 2848
       | infinity
       | -infinity
2849
       | 10/05/1947 23:59:12 PST
2850
       | invalid
2851
(7 rows)
2852 2853

RESET DateStyle;