Hi Andrew,
DATE_FORMAT is the function you're looking for.
Check the documentation on it, chapter 6.3.4 "Date and Time Functions".
DATE_FORMAT works like the following:
SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
BTW, SQL Server offers the CONVERT function for this purpose. No nee
Hi - I am relatively new to MySQL, previous experience is mainly Visual
FoxPro and MS SQL2000.
I have a client who supplies data in text files. In numerous of these
files and subsequent tables there are date fields.
In the UK we use the date format of dd/mm/. I understand that MySQL
on
