finding date in the FUTURE... HOW???

fux23

I'm putting into database date in format:
YYYY-MM-DD hh:mm:ss

for example:
$now = date("Y-m-d H:i:s");
//prints 2003-04-25 03:48:52

I have to add to this date some days and put it into database....

<b>HOW TO ADD TO THIS DATE for example 5 days and as a result get date in the same format :</b>

YYYY-MM-DD hh:mm:ss

??????

It should return:
2003-04-30 03:48:52

Thanks for Help

Mordecai

$now = date("Y-m-d H:i:s");
$then = date("Y-m-").(int)(date("d")+5).date(" H:i:s");

Just add 5.

fux23

$date_now = date("Y-m-d H:i:s");

$futuredate = mktime (date("H"),date("i"),date("s"), date("m"), date("d")+7, date("Y"));
$next_week = date("Y-m-d H:i:s", $futuredate);

🙂

bye

BuzzLY

Hehe... I thought this thread was about something else entirely 😃

PHPThorsten

You might also have a look at

http://www.phpinsider.com/php/code/Date_Calc/

OhLordy

lol Buzz 😃

Weedpacket

echo date('Y m d h:i:s', [man]strtotime[/man]('+5 days'));

Of course, if all you're doing is getting a date out of the database, adding 5 days to it, and putting it back in the database again, then it's a waste of time getting it out.

Assuming MySQL and its date and time functions:
UPDATE the_table SET the_date = ADDDATE(the_date, INTERVAL 5 DAYS) WHERE whatever_conditions_apply