SELECT (wanna change date format)

[LiamG]

Call me dumb, call me stupid. Go ahead, make my day.

 

I know how to do this, I just have a brain that loses cells often. As Homer once said, \"I don\'t wanna take an Adult Ed class Marge, coz everytime I learn something new, it pushes something old out of my brain. Like the time I took a wine tasting class and forgot how to drive\".

 

Anyway, as we all know (and love) that with mySQL, the DATE format is in YYY-MM-DD. YAY!

 

I have an $sql query:

[php:1:83022e15d7]

$sql=\"SELECT * FROM `table` WHERE 1 AND `category` = \'wateva\' ORDER BY \'date\'\";

[/php:1:83022e15d7]

Now, I want that to display, DD-MM-YYYY.

 

Yet again, call me dumb and stupid, how do I do that?

 

Thanks,

 

Liam Geteu.

[shivabharat]

This is will help u I guess

 

$year = substr( $tempdate, 0, 4);

$month = substr ( $tempdate, -4, 2);

$day = substr ($tempdate, -2);

$tempdate = sprintf(\"%02d-%02d-%04d\", $day, $month, $year);

[effigy]

have a look down the page at DATE_FORMAT

http://www.mysql.com/doc/en/Date_and_time_..._functions.html

if you use this you will have to name your columns instead of using *

 

if you prefer to do it afterwards in php - use the date() function in php - check www.php.net