Date Display

[mcmuney]

I'm sure this is very simple, but confusing to me.. how to display date in various formats. My database stores date as "1158340157" and when i display with this code [code]<?=$rs_mem[$i][date_added]?>[/code]

How and where do I specify the format of this?

[AndyB]

How was 1158340157 generated in the first place?

[kenrbnsn]

That looks like a UNIX timestamp. To convert it into something readable, use the [url=http://www.php.net/date]date()[/url] function.

[code]<?php
$nd = 1158340157;
echo date('Y-m-d',$nd);
?>[/code]

Ken

[pkSML]

If you'd like to display MM-DD-YYYY at HH:MM:SS, try this code:

[code]
<?php
echo date("m-d-Y \a\\t H:i:s",$rs_mem[$i][date_added]);
?>
code][/code]