This is how I'd do it:
$strtime = "20020531"; // Example date string
// STEP 1: Turn the YYYYMMDD string into a UNIX date
$unixtime = mktime(substr($strtime, 8, 2),substr($strtime, 10,
2),0,substr($strtime, 4, 2),substr($strtime, 6, 2),substr($strtime, 0, 4));
// STEP 2: Use the date() function to format the date however you'd like
echo date("m-d-Y", $unixtime); // Outputs 05-31-2002 echo date("d/m/Y",
$unixtime); // Outputs 31/05/2002
Things I highly recommend reading:
http://www.php.net/manual/en/function.substr.php
http://www.php.net/manual/en/function.mktime.php
http://www.php.net/manual/en/function.date.php
You'll really want to read the page about the date function. The options for
formatting your date output are just about limitless.
Gary Pullis
Office Management Technologies
http://www.omt.cc
> -----Original Message-----
> From: fabrizio [mailto:[EMAIL PROTECTED]]
> Sent: 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 ?
>
> thaks in advance,
> regards
>
> fabrizio
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
