MYSQL DateTime - PHP Conversion

Question

I have a MYSQL datetime that looks like this - 2011-08-28 12:39:21

I need (in PHP) to see if the time is within 3 minutes of the current time. I know how to do it in MySQL like 'BETWEEN NOW()-INTERVAL 3 MINUTE AND NOW()', But in this case I need to do it in PHP.

Advice on how to findout if the datetime is within the last 3 minutes or now?

cheers

Somnath Muluk · Accepted Answer · 2012-03-28 05:32:32Z

1

Use this function:

if (strtotime($datetime) >= time() - 180) {
    // within last three minutes or later
}

edited Mar 28, 2012 at 5:32

Somnath Muluk

58.3k39 gold badges225 silver badges230 bronze badges

answered Aug 28, 2011 at 2:50

deceze♦

525k89 gold badges807 silver badges954 bronze badges

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

Comments

arama motoru · Accepted Answer · 2011-08-28 03:35:52Z

0

This is not possible.

if (strtotime($datetime) >= time() - 180) {
    // within last three minutes or later
}

if you dont upgrade from your server MYSQL 5.2 and plus your dont fixed this.

answered Aug 28, 2011 at 3:35

arama motoru

11 bronze badge

Collectives™ on Stack Overflow

MYSQL DateTime - PHP Conversion

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