php timestamp conversion

[Phpfr3ak]

I've been looking at converting my php timestamps to display as month, day, and the hour and minute the event occurred on, i tried;

 

$time = date("j/n H:i", $Events['timestamp']);

 

But no success can anyone point me in the correct direction? Thanks

[Pikachu2000]

What format are they stored in?

[Phpfr3ak]

CURRENT_TIMESTAMP i.e 2012-02-02 04:00:04

[Pikachu2000]

I find it preferable to use MySQL's DATE_FORMAT() function and have them formatted and ready to go.

 

SELECT DATE_FORMAT(time_field, '%b %e, %H:%s') AS formatted_time FROM table

 

With the field alias AS formatted_time, the formatted date/time would be available in the ['formatted_time'] element of your associative array.

[Phpfr3ak]

$sql = "SELECT DATE_FORMAT(timestamp, '%b %e, %H:%s') AS formatted_time FROM ledger";

$que = mysql_query($sql) or die(mysql_error());

 

echo "<tr><td class='lil1'>$que[formatted_time]</td>";

 

would that be correct? sorry thinking i maybe read it wrong

[scootstah]

For the record, you can either pass the value to strtotime() to get a unix timestamp or use MySQL's UNIX_TIMESTAMP() function.

SELECT UNIX_TIMESTAMP(date) . . .

[Pikachu2000]

You still need to extract the results from the query resource with mysql_fetch_assoc(), and assuming you're expecting more than one result, it would be in this format:

 

$sql = "SELECT DATE_FORMAT(timestamp, '%b %e, %H:%s') AS formatted_time FROM ledger";
$que = mysql_query($sql) or die(mysql_error());
while( $array = mysql_fetch_assoc($que) ) {
     echo "<tr><td class='lil1'>$array[formatted_time]</td>";
}