Re: [PHP-DB] displaying a MySQL date in a different format

[Jeffrey_N_Dyke]

SELECT DATE_FORMAT(NOW(), '%m/%d/%Y');  will out put 01/04/2003.  replace
NOW() with you're column  name.

check out hte mysql manual for all of the date variations.
hth
jeff


                                                                                       
                               
                    "Ali McLeod"                                                       
                               
                    <alimcleod@btint       To:     [EMAIL PROTECTED]                
                               
                    ernet.com>             cc:                                         
                               
                                           Subject:     [PHP-DB] displaying a MySQL 
date in a different format        
                    01/04/2003 06:27                                                   
                               
                    PM                                                                 
                               
                                                                                       
                               
                                                                                       
                               




Can anyone help me. I am trying to display a date in a different format
from
that stored in a MySQL database. MySQL forces you to store it as yyyy-mm-dd
but I want to display it as dd-mm-yyyy, or dd-mmmm

Any ideas?

Many thanks in advance

Ali McLeod
[EMAIL PROTECTED]



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