Format the look of a timestamp

[86Stang]

I've got a timestamp that shows the last updated like this:

 

2008-05-07 10:36:35

 

The problem is that I'd like it to NOT show the time, just the date.  How can I make that happen with this:

 

$row[updated]

 

??

[The Little Guy]

Like this:

 

$t = strtotime($row[updated]);
echo date("m/d/Y g:i:s",$t);

 

returns: 05/07/2008 10:36:35

 

modify the date format for a different output

[mmarif4u]

OR,if u simply want to show date.

 

$date=date('m-d-Y',strtotime($row[updated]));
echo $date;

 

will return:

07-05-2008

[The Little Guy]

OR,if u simply want to show date.

 

$date=date('m-d-Y',strtotime($row[updated]));
echo $date;

 

will return:

07-05-2008

 

I believe it will be 05-07-2008, because I think the timestamp is formatted like so:

YYYY-MM-DD HH:MM:SS

 

[mmarif4u]

Oh,sori.

Should like this for that which i mention:

date('d-m-Y')

[PFMaBiSmAd]

To just show or use the date part of a DATETIME or mysql timestamp, use the mysql DATE() function -

 

DATE(expr)

 

Extracts the date part of the date or datetime expression expr.

 

mysql> SELECT DATE('2003-12-31 01:02:03');

        -> '2003-12-31'

 

To format a DATE, DATETIME or mysql Timestamp, use the mysql DATE_FORMAT() function -

 

DATE_FORMAT(date,format)

 

Formats the date value according to the format string.

 

The following specifiers may be used in the format string. The “%” character is required before format specifier characters.

 

... see the table in the mysql manual for complete information...