Code Forums - View Single Post - Problems in date DESC after changing format

sde · 04-02-2006, 08:59 AM

well i think i see your problem. AS article_date you are sorting by the article_date. i believe the order by clause is using the field name you specify after anything you do with it in the query.

try using AS formated_date and order by article_date desc

04-02-2006, 08:59 AM	#7 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,529	well i think i see your problem. AS article_date you are sorting by the article_date. i believe the order by clause is using the field name you specify after anything you do with it in the query. try using AS formated_date and order by article_date desc