dislpaying date uk FORMAT

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mohson
Forum Contributor
Posts: 372
Joined: Thu Dec 02, 2004 6:58 am
Location: London

dislpaying date uk FORMAT

Post 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?
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

Have a look at the DATE_FORMAT examples at http://dev.mysql.com/doc/mysql/en/Date_ ... tions.html
Post Reply