Date Formatting

[Dracolas]

http://www.sourcepod.com/qnayhd55-2681

How would i get it to give me the date as MM/DD/YY?

TY

[akitchin]

look in the MySQL manual at the DATE_FORMAT() function, which does exactly what you're asking. a script with that few lines is not a problem to paste here, and is easier to read here than having to jump to another link. please post in the forum for small scripts like this in future.

[Dracolas]

ok i understand what your saying and i get the use of Date_format(), but when i go to use it on my site with date being $date which is grabbed from the database it gives me error:

Warning: date_format() expects parameter 1 to be DateTime, string given in /home/a1237238/public_html/clan/home.php on line 20

what can i do to use this with the $date function... please assist

[akitchin]

you can edit this query:

 

$result = mysql_query("SELECT * FROM wars ORDER by id DESC");

 

to use DATE_FORMAT() on the `date` column. what did you try?

[Mchl]

Or you can do

$dateTime = new DateTime($row['date']);
echo $dateTime->format('M/j/y');

[salathe]

$dateTime->format('M/j/y');

 

It probably makes more sense to use m/d/y

[Mchl]

Maybe... I was writing this from top of my head...