date function

wuno

Hello

I used php date function to work out last month based on the current timestamp.

$last_month = date("Y-m-01",mktime(0, 0, 0, date("m")-1, date("d"), date("Y")));

The above code supposed to give the output 2006-02-01 given the current date 2006-03-31, but the output of the variable $last_month was 2006-03-01

What was wrong?

Norman

Weedpacket

Because 2006-03-31 minus one month is 2006-02-31, which is March 3rd (you don't see the third because of course you've got "01" hardwired instead of using "d"). What you're after is 2006-03-01 minus one month, which would be 2006-02-01.

$last_month = date("Y-m-01",mktime(0, 0, 0, date("m")-1, 1, date("Y")));

Rodney_H_

I think it is subtracting 28 days (number of days in February).

If you do the opposite and want to see next month, date("m") + 1

it works as expected...

Sorry I can't be more help than that......

TF_TheMoon

You have to be careful with PHP dates, there is a problem with cetain months having not enough seconds to actually make up a day. I seem to think it was november and march. I'm not sure if its been fixed though in the latest versions of PHP 4 and 5, its been a while since I looked

Weedpacket

TF@TheMoon wrote:
I seem to think it was november and march.

Congratulations; you've discovered Daylight Saving🙂

Rodney_H_

Weedpacket wrote:
Congratulations; you've discovered Daylight Saving🙂