MySQL & Unix timestamp query

Question

I have a db table that has the following structure: id (auto increment), title (varchar 255), datetime (datetime format)

I am trying to get all articles in the future, eg after current timestamp - would the query below look right? I have one row that has a datetime of 2012-01-19 10:02:20 so cannot understand why this isn't being shown in the results?

SELECT *, UNIX_TIMESTAMP(datetime) AS end_dateStamp 
FROM (`news`) WHERE UNIX_TIMESTAMP(`datetime`) > 1326991924

Ike Walker · Accepted Answer · 2012-01-19 17:10:16Z

2

Try this:

SELECT *, UNIX_TIMESTAMP(datetime) AS end_dateStamp 
FROM `news` 
WHERE `datetime` > NOW()

answered Jan 19, 2012 at 17:10

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

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

Comments

knittl · Accepted Answer · 2012-01-19 17:08:37Z

2

You can simply use mysql's NOW() function:

SELECT *, UNIX_TIMESTAMP(datetime) AS end_dateStamp 
FROM (`news`) WHERE `datetime` > NOW()

answered Jan 19, 2012 at 17:08

knittl

269k59 gold badges339 silver badges405 bronze badges

Collectives™ on Stack Overflow

MySQL & Unix timestamp query

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