Getting formatted date/time from mySQL DB

[chrima]

Hi all,
Why won't this query work?

$sql = "SELECT *, date_format(order_date, '%d, %b, $Y') FROM orders WHERE processed = 'N' ORDER BY order_date DESC";

Can anyone tell me how to rectify this?

Cheers,
chrima

[barand]

Try %Y instead of $Y

[trooper]

also you may want to refer to the date via an alias as it makes it easier later on

GM