how to display MySQL timestamp?

[jr_yeo]

ive got database with a date field. when i extracted the data, the format is something like "2003-12-25 23:59:59". how do i "reformat" it to something like
"Thursday, December 25, 2003 23:59". i tried

echo date("F j Y H:i:s T", $row["date"]); 

the date/time outputted resets to January 1 1970 00:33:29 UTC.

tnx.

[Nile]

Here you go:

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]);
}
echo date("l, F j, Y H:i", displayToMk($row["date")); 

[Twey]

By chaining it through strptime() and then back through date():

date('F j Y H:i:s T', strptime('%Y-%m-%d %T', $row['date']));

[jr_yeo]

Fatal error: Call to undefined function strptime()

[Schmoopy]

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

[jr_yeo]

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

why won't it work?

[Schmoopy]

strptime : Scroll a bit down the page

Note: This function is not implemented on Windows platforms.

[Nile]

Mine will work on Windows.

Although if you're using this on a website and your website isn't hosted on a windows server then go ahead and try Twey's on your site, and not a localhost,

[jr_yeo]

strptime : Scroll a bit down the page.

Note: This function is not implemented on Windows platforms.

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

[jr_yeo]

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