I am trying to write a code in php where I retrieve the DateTime from the database and find what time is it 15 minutes before the DateTime.

Such as

//Receiving the Start Time from the database.
$time1 = "2012-03-17 15:00:00";

//Reformating time to get the date 1hr or 1min or 15mins before Start Time.
$reminder = date("g:i", strtotime("-15 minutes", $time1));

echo $reminder;

But the only problem with the concept I have above is it prints out 7:00:09.

Can any one help me solve this issue please and thank you.


5 Years
Discussion Span
Last Post by programmer12

Heres how i would do it:

echo date("Y-m-d H:i:s");
echo "<br/><br/>";
echo date("Y-m-d H:i:s",strtotime("-15 minutes",strtotime(date("Y-m-d H:i:s"))));

You should also watch if your mysql time going out of sync of your server time could be an issue, i hit a similar problem recently where the mysql was 3 hours out of sync with the server running the php script making things break and log incorrectly!


Oh yeah, I forgot about that. That might be the issue. I will need to change the PHP.ini file to say my

Thanks so much for your help! =) I really appreciate it

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.