on 6/10/02 9:00 AM, fabrizio at [EMAIL PROTECTED] appended the following bits
to my mbox:

> 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 ?

In your query, you can use the MySQL date_format function.  See the
documentation here:

<http://www.mysql.com/doc/D/a/Date_and_time_functions.html>

Example:

SELECT movie_title, DATE_FORMAT(movie_start_date, '%m/%d/%Y') AS
start_date_formatted FROM movies_table WHERE movie_id="3";

Hope that helps.

Sincerely,

Paul Burney
<http://paulburney.com/>

<?php

// the statement formerly known as prince
if ($the_elevator == 'tries to bring you down') {
    go_crazy('punch a higher floor');
} 

?>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to