Date formating with sql and php

[Anon]

I'm a newb, so please bear with me.

I have an MySQL database with a date field in the format of yymmdd.

When I display this date on a web page using php, of course it's in the above format.

I've attempted using the date() function, to achieve a format of yy-mm-dd, but have been getting really odd results.

$mapdate = date("y-m-d", 010415);
print "Mapdate is $mapdate";

would out put something like

Mapdate is: 69.12.31

As you can see that date is not even close 🙂, Any help would be much appreciated!

[Anon]

Read the manual and the user comments on php.net. date() doesn't take what you gave it as a valid parameter.

[melvyn]

If this is a real DATE field in mysql, simple use:
UNIX_TIMESTAMP(datefield)

in your query, since the php date function needs exactly that.