Anyango - 5:09 am on Sep 2, 2010 (gmt 0)

i would suggest save UNIX timestamp in the db and then run date time functions to make it look like a date. it makes life much easier and faster for me.

for that you will need to have a mysql field INT(11) and from php you will send

$ts=time();

then you can easily run date() function to display it, for example

if you pick $yourSavedTs from db then you could do


echo date("F j, Y, g:i a",$yourSavedTs);