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
