Date Format

[Bman900]

I was writing a blog system and when I got to the date stamp it comes out as 2010-01-20 and I want it as 01/11/2010.

 

I did directly insert this with phpmyadmin because I did not get to the point where I have a back end for this. But how would I insert this into a query with php?

[wildteen88]

You can format your dates by first using the strtotime function to convert your date into a unix timestamp. You then pass the timestamp as the second parameter to the date function. This will allow you to change the appearance of your date.

[mikesta707]

alternatively, you can use the mysql Date Format function to format the date inside the query itself