Hello dear all,
in my mysql-db I have a date_tbl with this format: (20020531).
how is possible in PHP do display date_tbl's values in a more human-readable
format like 05-31-2002 or 31/05/2002 ?
thaks in advance,
regards
fabrizio
--
PHP Database Mailing List (http://www.php.net/)
Monday, June 10, 2002, 2:00:59 PM, you wrote:
in my mysql-db I have a date_tbl with this format: (20020531).
how is possible in PHP do display date_tbl's values in a more human-readable
format like 05-31-2002 or 31/05/2002 ?
Look at date and strtotime...
http://www.php.net/date
This function will fix your date display.
$sqldate=20020531;
$sqldate= fixdate($sqldate);
function fixdate($data){
$aux=;
$z=0;
for($i=0; $istrlen($data); $i++) {
if($i=3) {
$aux[0].=$data[$i];
}
if($i==4 or $i==5) {
$aux[1].=$data[$i];
}
if($i==6 or $i==7) {
: Monday, June 10, 2002 9:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] date format display
Hello dear all,
in my mysql-db I have a date_tbl with this format: (20020531).
how is possible in PHP do display date_tbl's values in a more
human-readable
format like 05-31-2002 or 31/05/2002