Time stamp and adding 1 year and last day in month

Question

I have timestamp in DB like: 1268085720, it's 2010-03-08 23:00, so it's today.

How can I add one year, and to be the last day in the same month, and need to convert it like: YYYY-MM-DD HH: MM?

For given example I need 2011-03-31 23:59.

score 1 · Accepted Answer · edited May 23 '17 at 12:19

1

Modification of How to find the last day of the month from date?

echo date("Y-m-t 23:59:59", strtotime("+1 year", 1268085720));
// -> 2011-03-31 23:59:59

The t format gives the number of days in the given month (28 through 31). If you want the real hours and minutes, use Y-m-t H:i:s instead of the hardcoded time.

edited May 23 '17 at 12:19

Community

1
1

answered Mar 08 '10 at 21:33

Gordon

312,688
75
539
559

Daan · Answer 2 · 2010-03-08T22:04:54.060

0

Use mktime();

$time=1268085720;
$nextyear=mktime(date('h', $time), date('i', $time), date('s', $time), date('m', $time), date('t', $time), date('Y', $time)+1);

edited Mar 08 '10 at 22:04

answered Mar 08 '10 at 21:16

Daan

1,879
17
18

This gives 2015-09-01 on my computer when run through date(Y-m-d) – Gordon Mar 08 '10 at 21:27
Oups! I forgot to include the current day... xD --Edited. – Daan Mar 08 '10 at 21:39
Now it returns 2011-03-08. Still not what the OP was looking for. Use `date('t', $time)` instead of `date('d', $time)` – Gordon Mar 08 '10 at 21:43

Marcx · Answer 3 · 2010-03-08T22:59:11.680

0

//$result contain the timestamp
$lastday=strtotime('+1 year', $result);
echo date('Y-m-t H:i',$lastday);

here :)

edited Mar 08 '10 at 22:59

answered Mar 08 '10 at 21:19

Marcx

6,806
5
46
69

"last day" is "yesterday" in strotime whereas I think the OP was last day of month – Gordon Mar 08 '10 at 21:22

Time stamp and adding 1 year and last day in month

3 Answers3