Daily Archives: April 15, 2010

PHP/MySQL datetime formatting bypassing UNIX_TIMESTAMP

PHP/MySQL datetime formatting bypassing UNIX_TIMESTAMP Formatting MySQL date to something useful has been a pain for PHP developers for a long time. Usually you would make your query return the datetime using UNIX_TTIMESTAMP and then using PHP date function, format it to your heart’s content like this: echo date(“F jS, Y h:i:s A”, $row->date); But…