CODEWITHSUNDEEP
mysqlsqldatabasephpmyadmin
Elyas Nice
Elyas Nice

Reputation: 43

SQL: Check if now Timestamp is greater than expired Timestamp

I want to Check if the Timestamp of now is greater than my Expired Timestamp:

id  |  created_timestamp  |   expired_timestamp
1   |     1542570971      |   1542743771

I have tried:

SELECT * FROM premium WHERE expired_timestamp >= now();

Nothing works :/

Upvotes: 3

Views: 1473

Answers (2)

Madhur Bhaiya
Madhur Bhaiya

Reputation: 28834

You simply need to use UNIX_TIMESTAMP() function:

SELECT * FROM premium 
WHERE expired_timestamp >= UNIX_TIMESTAMP();

NOW() function returns current datetime in YYYY-MM-DD HH:MM:SS format. While Unix_Timestamp() function will return the current datetime's unix timestamp value (unsigned integer). You need to use the latter in your case.

Upvotes: 4

Gordon Linoff
Gordon Linoff

Reputation: 1269623

I think you want UNIX_TIMESTAMP():

SELECT *
FROM premium
WHERE expired_timestamp >= UNIX_TIMETAMP();

Upvotes: 2

Related Questions