Re: [PHP-DB] date format display From: Paul Burney (paul.lists <email protected>)
Date: 06/10/02

on 6/10/02 9:00 AM, fabrizio at fabrizio <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