how to display MySQL timestamp?

[Nile]

function displayToMk($date){ 
  $date = explode(" ", $date); 
  $date[0] = explode("-", $date[0]); 
  $date[1] = explode(":", $date[1]); 
  return mktime($date[1][0], $date[1][1], $date[1][2], $date[0][1], $date[0][2], $date[0][0]); 
} 
$query1 = "SELECT date FROM $tablename"; 
$result = mysql_query($query1) or die('Error, query failed'); 
while($row = mysql_fetch_array($result)) { 
  echo '<td align=right>' . date('F j Y H:i:s T', displayToMk($row["date")) . '</td></tr>'. "\n"; 
} 

[jr_yeo]

@Schmoopy

Make sure your server is not running on Windows, or it won't work.

tried Twey's on Linux.

how do i implement it now?

$query1 = "SELECT date FROM $tablename";
$result = mysql_query($query1) or die('Error, query failed');
while($row = mysql_fetch_array($result)) {
echo '<td align=right>' . date('F j Y H:i:s T', strptime('%Y-%m-%d %T', $row['date'])) . '</td></tr>'. "\n";
} 

the date still reverts back to January 1 1970 not the CURRENT_TIMESTAMP

dont worry Nile, yours works just fine in both platforms

[Nile]

I'm saying - use mine, not one that will work on all servers.

By any change do you know if your server is hosted on Windows, Linux, or Mac?

[jr_yeo]

i did use your code

m localhost on Windows and Linux.

but does it matter if mine is locally hosted and need to be on remote host/server?

[Twey]

Sorry, I got the arguments the wrong way around. It should be date('F j Y H:i:s T', strptime($row['date'], '%Y-%m-%d %T')).

it doesn't still explain why it won't work in windows.

Well, yes, it does. The function isn't implemented there, therefore it can't.

A better solution to this would be to implement strptime() in PHP if it doesn't already exist, though it seems a bit tedious. It's fairly simple to parse out the assorted values, but then there are about fifty different scales to apply, which has to be done manually as far as I can see.

Edit: I see that strptime() is not a strict inverse of strftime(). While strftime() takes a time_t/timestamp, strptime() returns a struct/array of various values. This does make it easier to implement, but unfortunately it also means that it's less useful for your situation.

[jr_yeo]

Warning: date() expects parameter 2 to be long, array given in my filename.php