*** ./expected/timestamp.out Sat Nov 25 00:00:31 2000 --- ./results/timestamp.out Mon Apr 2 09:54:50 2001 *************** *** 7,13 **** SELECT (timestamp 'today' = (timestamp 'yesterday' + interval '1 day')) as "True"; True ------ ! t (1 row) SELECT (timestamp 'today' = (timestamp 'tomorrow' - interval '1 day')) as "True"; --- 7,13 ---- SELECT (timestamp 'today' = (timestamp 'yesterday' + interval '1 day')) as "True"; True ------ ! f (1 row) SELECT (timestamp 'today' = (timestamp 'tomorrow' - interval '1 day')) as "True"; *************** *** 19,25 **** SELECT (timestamp 'tomorrow' = (timestamp 'yesterday' + interval '2 days')) as "True"; True ------ ! t (1 row) SELECT (timestamp 'current' = 'now') as "True"; --- 19,25 ---- SELECT (timestamp 'tomorrow' = (timestamp 'yesterday' + interval '2 days')) as "True"; True ------ ! f (1 row) SELECT (timestamp 'current' = 'now') as "True"; *************** *** 87,93 **** SELECT count(*) AS one FROM TIMESTAMP_TBL WHERE d1 = timestamp 'today' - interval '1 day'; one ----- ! 1 (1 row) SELECT count(*) AS one FROM TIMESTAMP_TBL WHERE d1 = timestamp 'now'; --- 87,93 ---- SELECT count(*) AS one FROM TIMESTAMP_TBL WHERE d1 = timestamp 'today' - interval '1 day'; one ----- ! 0 (1 row) SELECT count(*) AS one FROM TIMESTAMP_TBL WHERE d1 = timestamp 'now'; ======================================================================