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
---------------------------------------------------------------------
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