Page 1 of 1

dislpaying date uk FORMAT

Posted: Mon Dec 20, 2004 5:56 am
by mohson
OK,

heres my query:

Code: Select all

$query = "SELECT * FROM people ORDER BY firstname";
this displays all the the results from the table but how do i Adjust this query so that the date displays in dd/mm/yyyy rather that 0000/00/00 the two date fields are : dateoflastcontact AND datecontactagain

Can anyone help?

Posted: Mon Dec 20, 2004 9:44 am
by markl999
Have a look at the DATE_FORMAT examples at http://dev.mysql.com/doc/mysql/en/Date_ ... tions.html