Convert date format from mysql TIMESTAMP help
have one problem, I need the dates in Swedish format, for instance, october is in swedish oktober... How can I do this?
This works so far for engli开发者_如何学Csh dates:
$date = date( "j F", strtotime( $row[insert_date] ) );
$display_table .= "$date";
Something like this might help:
$date = date( "j F", strtotime( $row[insert_date] ) );
$display_table .= "<td width='67' rowspan='2'>$date</td>";
An alternative to Rudisimo's answer is making mysql do the work for you:
SELECT DATE_FORMAT(`insert_date`,'%d %M') AS insert_date FROM `table_name` WHERE [...]
精彩评论