Working with timestamp

[snapbackz]

$date = date("F d\, Y g:ia", strtotime('2007-12-05 03:25:55'));

How can i output the date/time above in the same format but 3 hours before?

It's comming from a MySQL datetime column so I need to use that format. What im trying to do is compare if the last login date is >= 3 hours before the current date/time.

[zabmilenko]

Off the top of my head:

$date = date("F d\, Y g:ia", strtotime('2007-12-05 03:25:55') - (3600 * 3));

Since timestamps are in seconds, you just take 60 seconds times 60 minutes times 3 hours.

[Weedpacket]

Or

$date = date("F d\, Y g:ia", strtotime('2007-12-05 03:25:55 - 3 hours')); 

snapbackz wrote:

It's comming from a MySQL datetime column so I need to use that format. What im trying to do is compare if the last login date is >= 3 hours before the current date/time.

In that case you would probably be better off using MySQL's functionality for handling datetime values and making the comparison part of the database query.

[bradgrafelman]

SELECT IF(DATE_SUB(NOW(), INTERVAL 3 HOURS) > last_login, 1, 0) AS foo FROM myTable

'foo' will then be '1' or '0', '1' meaning that they haven't logged in within the past 3 hours, '0' meaning they have.