How to display rows where date is less than x time

Question

SELECT * FROM `votes` WHERE `forserverid`='518' AND `date` ?????

The date columns contains a unix timestamp, how do I make it so it only shows rows where the unix timestamp in the date column is less than X time (3 hours in my case). i want to do this filter within the mysql query if possible.

Thanks :)

@Nemoden That didn't work, I'm not using a "date" column, It's just a regular column with a unix timestamp in it. — Stranger20, May 26 '17 at 00:07
Three hours compared against which time? (date column > ? + 3hs) — Juan, May 26 '17 at 00:08
@Juan I have a unix timestamp stored in the date column, I want it to only shows rows that are not older than three hours. — Stranger20, May 26 '17 at 00:13
@MassacreGamingnet is it an `int` / `INTEGER` column or a text column? If it's a text column then you'll have poor query performance because converting text to `int` is a non-SARGable operation. — Dai, May 26 '17 at 00:19

score 0 · Accepted Answer · answered May 26 '17 at 00:19

0

Unix time stamp is in secods so 3 hs are 3 * 60 * 60 seconds.

The condition should be date < UNIX_TIMESTAMP(NOW()) - 3 * 60 * 60

answered May 26 '17 at 00:19

Juan

5,525
2
15
26

Worked, thank you! You're awesome! ;) – Stranger20 May 26 '17 at 00:23

How to display rows where date is less than x time

1 Answers1