[RESOLVED] mktime reading -1 month

middleman666

hey people,

I have a datetime stamp on my mysql database i.e: 2006-12-05 20:23:51

Which is December 2006.

I want to read the month and year from that date using mktime so I did this:

$id = '2006-12';
date("F Y", mktime ( 0, 0, 0, substr($id,5,2), 0, substr($id,0,4)))

But when I do that it reads out:
November 2006

I did it on a number of dates and they all seem to be reading out the previous month to what it should be.

So to fix this I done this:

$id = '2006-12';
date("F Y", mktime ( 0, 0, 0, substr($id,5,2)+1, 0, substr($id,0,4)))

But I don't see why I should have to do that?

Does anyone know why it wouldn't just read it out properly?

Thanks

leatherback

Why not use the dateformat() command in mysql when you retrieve the data in the first place?

edit:
"select *, DATE_FORMAT(DATECOLUM, '%m %Y') as date ... ";

middleman666

Sorry, I didn't expalin before - the $id is taken from the URL i.e $id=$_GET['id'];

I do use the dateformat() option on the previous page to create the link with the $id value in it.

leatherback

hm.. Makes me wonder why you not just pass a record ID instead of a date, but. THat i snot your problem.

It might be because you specify day as 0. As there is no day number 0 in a month, the date function might jump to the previous month. All I can guess ...

middleman666

You were correct 🙂 I added day as 1 insted and now it's fine.

Cheers!