Date and Time Formatting

I have a PHP file which put a record into a MySql database and when it enters this record it also stores the current Date of the record entry.

This is working great until I retrive the date because it is coming out in its native format, Year Month date

Is it a question of formatting before entry or on the retrieval

Thanx for any help

Mike,

You can format the date using MySQL functions.

$query = mysql_query("SELECT DATE_FORMAT(CURRENT_DATE(),'d-m-y') AS dateformat FROM tablename");

$result = mysql_fetch_array($query);

print $result["dateformat"];

Hope this helps

Mike
www.digitalegg.net

what he said - alternatively you can use INT fields to store dates as system timestamps (number of seconds since beginning of unix epoch)

That way you can also easily do date math by adding or subtracting seconds (86400 per day) to the stored value

$timestamp = mktime()

You only need to convert the timestamp on screen output

date("d M Y",$timestamp) will be dd Mmm yyyy format....