Adding a day to a timestamp - can't get it to work

joshmpratt

I'm pulling a variable in from a database. It's a timestamp in this format:

20060926000000 - Today at the turn of the day.

How can I add a day to that, and make sure that I get the correct date, especially if its the turn of the month with php?

I tried this, but it doesn't work:

$newtime = date('YmdHis', ($databasetime + 1000000));

devinemke

echo date('YmdHis', strtotime('20060926000000 +1 day'));

joshmpratt

What if I wanted to replace the actual timestamp there (the 20060926000000) with a variable? I can't seem to get the right syntax...

devinemke

$var = '20060926000000';
echo date('YmdHis', strtotime($var . ' +1 day'));

joshmpratt

It doesn't work... Instead I'm getting this as a result: 19691231175959

ClarkF1

That's because 20060926000000 is not a UNIX timestamp, it's a MYSQL timestamp.

You need to use UNIX_TIMESTAMP in the database query to convert it.

Then you can add 86400 (the number of seconds in a day)

Weedpacket

ClarkF1 wrote:
86400 (the number of seconds in a day)

Except when it's something else.

There is also the option of having the database add the day, and perhaps even formatting it (though I'd prefer to get a Unix timestamp, occasionally that's not feasible.)

Salkcin

joshmpratt wrote:
It doesn't work... Instead I'm getting this as a result: 19691231175959

works great for me...

well, you can delete the time and only leave the actual date and then add 1 day to it, ex:

$var = '20060926000000';
$var = substr($var, 0, -6); // remove time and only leave the date

echo date('Ymd', strtotime("$var +1 day"));

Weedpacket

It would still be better to use MySQL's date/time formatting functions to format a MySQL timestamp.... that's what they're there for, after all.

And if you're going to use substr() you might as well use it a couple more times to get separate year, month, and day values, then use mktime() to put them together (with 1 added to the day).