>Hi,
>
>I`m selecting information from my MySQL as follows...
>
>Select * FROM Features WHERE Platform='pc' and Public='Y' Order by DateTime
>ASC LIMIT 0,3
>
>I am storing the field DateTime as a date when selected it looks like this
>2001-05-05 but I want to change it so it looks like May 5th 2001, I`ve looked
>about and found the DATE_FORMAT method but I have no idea how to use it on my
>select without it effecting my Order by, anyone have any tips?
>
>Thanks
>Ade
Sir, change the name of your DateTime column. DateTime is a reserved
word. Even if it isn't causing you problems now, it will in the
future.
Why would reformatting the date in your SELECT clause alter the the
way your ORDER BY clause works? You're only reformatting the output.
You're not changing the data in the column, and your ORDER BY refers
to the name of the column, not to an alias for the reformatted output.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
