Redshift Fun

gistfile1.txt

logs=# create table timestamp_test (a timestamp, b timestamp);
CREATE TABLE
logs=# insert into timestamp_test(a,b) values('2015-04-25 06:29:40', '2015-04-25 06:35:36');
INSERT 0 1
logs=# select b-a from timestamp_test where b-a > 3000;
 ?column?
-----------
 356000000
(1 row)

logs=# select b-a from timestamp_test where b-a > 6000;
 ?column?
----------
(0 rows)

logs=# insert into timestamp_test(a,b) values('2015-04-25 06:13:14', '2015-04-25 06:13:19');
INSERT 0 1


logs=# insert into timestamp_test(a,b) values('2015-04-25 06:13:14', '2015-04-25 06:13:19');
INSERT 0 1
logs=# select b-a from timestamp_test where b-a > 3000;
 ?column?
-----------
 356000000
 5000000
(2 rows)

logs=# select b-a from timestamp_test where b-a > 5000;
 ?column?
----------
 5000000
(1 row)