View Single Post
  #2 (permalink)  
Old Dec 16th, 2004, 15:54
Webforumz Staff Webforumz Staff is offline
Most Reputable Member
Join Date: Jul 2003
Posts: 1,856
Thanks: 0
Thanked 0 Times in 0 Posts
I've got about 2 mins to answer your question, so let me just point you in the right direction! PHP has some handy date functions for manipulating the date field in mysql.

http://www.php.net/manual/en/ref.datetime.php

The one that probably interests you is date() which allows you to format a date to display in any way you want.
However, there are several ways to store a date in MySQL, so ensure that you're using the method that suits your application best. If in doubt, head over to http://dev.mysql.com/doc/mysql/en/Da..._overview.html

If you're still having trouble when I get back then let me know and I'll try to help some more.