Postgres query compare if two dates are equal with margin

Question

I have the following query in Postgres:

SELECT * FROM users WHERE registration = last_login;

Both registration and last_login are timestamps. The problem I have is that those two values are written with some tiny difference, but they are not exact. Is there any way I can compare those two dates with a margin of, say, 1 second?

NLink · Accepted Answer · 2016-05-20 09:26:13Z

6

a_horse_with_no_name actualy has answered your question but just for case when there's no guarantee one date is after another you could try something like this:

SELECT *
FROM users
WHERE @extract(epoch from registration - last_login) <= 1;

extract(epoch from some_interval) returns timestamp difference in seconds as a number, and @some_value returns absolute value of a number, just like abs(some_value)

edited May 20, 2016 at 9:26

answered May 20, 2016 at 7:03

NLink

4852 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user330315 · Accepted Answer · 2016-05-19 12:15:41Z

1

Assuming that last_login is always after registration, you can check the difference between the two timestamps

select *
from users
where last_login - registration <= interval '1' second

answered May 19, 2016 at 12:15

user330315

Collectives™ on Stack Overflow

Postgres query compare if two dates are equal with margin

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related