add month to date();

[mrdance]

I use this function to get a date;

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

How do I add 3 months to the date?

Thanks!

[Anon]

Look at the mktime function. This is what you want to use to do date math. The date function is only used to make a nice looking date from a timestamp.

[sepodati]

If this is for a mysql database at all, please let me know what you're trying to do, overall. There are real easy ways to do date math in mysql.

---John Holmes...

[mrdance]

I tried using this function with no success;

$newdate= date("Y-m-d H:i:s", mktime(date("m")+3));

[sepodati]

did you look at the manual for mktime? It has six parameters...

mktime(hour,minute,second,day,month,year)

So, use current values for day and year, but add 3 to month...

$new_date = date("Y-m-d H:i:s",mktime(0,0,0,date("d"),date("m")+3,date("Y")));

I think that'll work.

You never answered if this has anything to do with MySQL...

---John Holmes...

[mrdance]

I looked in the manual and used that code. But it added one year 9,5 month and reseted the time to 0:00:00. I don´t know why..

MySQL? Yes I just want to change a date before adding it to the database.

[sepodati]

Then it's a whole lot easier to use MySQL to do this...

INSERT INTO your_table (time_column) VALUES (NOW() + INTERVAL 3 MONTH);

Try that...

---John Holmes...

[mrdance]

thanks for your suggestion!