php date formatting with MySQL SHOW TABLE STATUS

probably missing something simple:

<?php
$con=mysql_connect('localhost','xxx','xxx');

$db=mysql_select_db('xxx');

$sql = mysql_query("SHOW TABLE STATUS WHERE `name`=\"my_table\"");

$foo=mysql_fetch_array($sql);

return $foo['Update_time'];

// returns 2010-03-31 16:51:06
?>

how do i format this. I tried using

date('l jS F Y @ H:i:s', $foo['Update_time']);

but this returns:

Thursday 1st January 1970 @ 01:33:30

presumably as date() expects a timestamp.

thanks..im sure this is very obvious but my minds gone blank

Answers


The date function expects an UNIX Timestamp as its second parameter -- and not a string containing a date.

This means you have to convert that string to a timestamp -- which can be done using the strtotime function :

$ts = strtotime($foo['Update_time']);
echo date('l jS F Y @ H:i:s', $ts);

Note 1 : the YYYY-MM-DD HH-MM-SS format is well understood by strtotime ; which is often helpful, when dealing with dates that come from MySQL.

Note 2 : Using date and strtotime, which work on timestamps (reprenseted as 32 bits integers, counting the number of seconds since 1970-01-01), you will be limited to dates between 1970 and 2038 ; if you need to work with dates outside of that range, you'll have to use the DateTime class.


This should work:

date('l jS F Y @ H:i:s', strtotime($foo['Update_time']));

strtotime() will take a date string and turn it into a timestamp, which you can then use with date().


You need to use strtotime function:

date('l jS F Y @ H:i:s', strtotime($foo['Update_time']));

Need Your Help

Moving image left and right with jQuery

javascript jquery html image

OK, here is the updated, and working code. Making the image relative did the trick. Now the only thing left is as soon as I remove my finger from the key, I want the image to stop moving. How would I

Java: Are concurrent reads and writes possible on a blocking SocketChannel via Object(In|Out)putStreams?

java sockets nio

I created an ObjectInputSteam and ObjectOutputStream on a blocking SocketChannel and am trying to read and write concurrently. My code is something like this: