Hello,
>The column is set as "date timestamp(8)".
>A sample of date is "20020409"
>
>I use the PHP Date function to format it back to say "9th April 2002".
>$date_formated = date($date, 'S M Y' );
How about this;
$date_formatted=date("jS M Y",mktime(0,0,0,substr($date,4,2),substr
($date,6,2),substr($date,0,4)));
However I guess this is proper 4 U;
$date_formatted=date("jS F Y",mktime(0,0,0,substr($date,4,2),substr
($date,6,2),substr($date,0,4)));
Hiroshi Ayukawa
http://hoover.ktplan.ne.jp/kaihatsu/php_en/index.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
