brady.k — Fri, 27 Apr 2007 01:40:45 +0000

You can do things like

SELECT things FROM wherever ORDER BY date_stamp DESC

'
and it just 'magically' works.

As for outputting, you can just pull the data out of the database, and format it. For example (in PHP):

$sql = mysql_query("SELECT date_stamp FROM whatever WHERE id = '$id'");
$qry = mysql_fetch_array($sql);

$pre_date = $qry['date_stamp'];
$format = 'D of F';

$form_date = date($format, strtotime($pre_date));

echo $form_date;

Presto.

benf — Fri, 27 Apr 2007 01:30:49 +0000

thanks, i deleted my inserts in the script becuase i gave up and now just checked and there all there!!
So i can still order by date even though they are actually in a date format? Mysql and php will know will they?

i can use the date() function to out put them?

Abhishek Reddy — Thu, 26 Apr 2007 22:27:07 +0000

The database will create the timestamp for you. You don't have to supply a value using PHP's time().

benf — Thu, 26 Apr 2007 18:21:23 +0000

I cant seem to insert a timestamp in to mysql? I have used this in my query to insert the timestamp:

Date_created='time()',

My database field is set to "timestamp", and default "CURRENT_TIMESTAMP" attributes " ON UPDATE CURRENT_TIMESTAMP" but when i insert into the database it stays at this:

0000-00-00 00:00:00

Abhishek Reddy — Sun, 11 Feb 2007 12:41:18 +0000

Post the code you ran to get correct and incorrect dates. The only ways I can think of to get an incorrect date in 1969 is if you supplied an improper timestamp, or if the system's time is itself wrong.

The timestamp doesn't need to be in []. The square bracket notation just means the parameter is optional. In this case, missing the timestamp argument will cause it to default to the value of time().

benf — Sat, 10 Feb 2007 03:00:54 +0000

mmmm yes this has been done only a few of the dates are ok but some are coming out saying 1969? Does the time stamp have to be in []?

Greg K — Sat, 10 Feb 2007 02:47:34 +0000

See http://www.php.net/date for more info.

-Greg

demonhale — Sat, 10 Feb 2007 02:36:16 +0000

This

date("date format",[timestamp])

or this

date("F j, Y, g:i a")