mySQL datetime problem

[Anon]

Hi,

I have insert the date/time from php into mySQL database. Data type in mySQL database is in DATETIME format. It works fine when I insert it in 2000-10-17 16:26:30 format. Now, I want to retrieve this date and show in PHP in 17-Oct-2000 format. How can I do this?
The date(); time(); and other date/time functions from PHP seems didn't accept the arguement (date) from database. Please help.

Thanks.

[Anon]

Read the MySQL manual:

-- begin quote --

DAYNAME(date)
Returns the name of the weekday for date.

 mysql> select DAYNAME(\"1998-02-05\");
         -> \'Thursday\'

-- end quote --

There are many similar ways of retreiving other date information
from date and datetime fields.
Use the mysql concat() function to append day, month amd year into one string.

[Anon]

There's a mySQL function called 'DATE_FORMAT' that does exactly what you want: If your date field is called 'datefield', for instance, try your select statement as something like

SELECT DATE_FORMAT(datefield, "%d-%b-%Y") FROM table.

There are plenty of other options too, but that should do it for you.