php sql date time comparison

Question

I have a last_notified column on my MySQL table, data type DATETIME I want to either only select the rows where last_notified is more than n seconds old, or compare the last_notified value from the db in php.

I have tried messing around with the date object.

$d = date('Y-m-d H:i:s'); // current date and time
$dd = date('2011-09-08 10:21:34'); // this is the format used in mysql.

I know I cannot just compare them, and i'm unaware of how to add time to the date object. I have seen examples of people using something along the lines of

$t = explode(" ",$dd);
date($dd, strtotime('+30 minutes', strtotime($t[1])));

but that doesn't work . I'm just not seeing it.

xdazz · Accepted Answer · 2011-09-08 14:51:09Z

2

You can use sql like this:

SELECT * FROM your_table WHERE last_notified < DATE_SUB(NOW(), INTERVAL n SECOND)

answered Sep 8, 2011 at 14:51

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

1 Comment

jeremysawesome Over a year ago

nice xdazz! you beat me to the punch!

heximal · Accepted Answer · 2011-09-08 14:47:14Z

1

Take a look at your first snippet and date mask in first line

Y-m-d H:m:s

you use m mask twice, so it means there will be month instead of minutes. you should use i mask to specify the minutes

answered Sep 8, 2011 at 14:47

heximal

10.5k5 gold badges49 silver badges73 bronze badges

Comments

jeremysawesome · Accepted Answer · 2011-09-08 14:52:27Z

1

SELECT * FROM your_table WHERE last_notified < DATE_SUB(NOW(), INTERVAL n SECOND)

answered Sep 8, 2011 at 14:52

jeremysawesome

7,2745 gold badges35 silver badges38 bronze badges

Collectives™ on Stack Overflow

php sql date time comparison

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related