Hi all,

I use php and mySQL for my website. I just found out that sometimes a date goes weeeeeeee....

I have a "birthday"field in my table, which i retrieve from my php script, and put it in a var, let say $BIRTHDAY.

Since the format of mySQL dates are not what I like, I change the format to another like this:

$formatted = strftime("%d %B",strtotime($BIRTHDAY));

As you see, I only want the day and month. This seemed to work fine, until i found that one date does't show up... It was a birthday from someone born in 1966 ... When i changed it to i.e. 1980 it worked fine.

Is this some kind of "bug"in the function strtotime() or strftime(), or even mySQL? However, in the database, i see the date is correct... (Years before the year 19XX are not recognized?)

Anyone please?

Guys,

I really am stuck here.... It doesn't work as i expect it??

Unix epoch seconds start on January 1st 1970 so any dates before this that you try to represent using epoch seconds will fail. You'll need to consider storing the dates in a another format.

cheers

Jamie...