Re: MySQL and DATE display problem

Try the "date" function : date("d/m/Y",$date). See the OnLine manual for more details. Jayme. http://www.conex.com.br/jjeffman -----Mensagem Original----- De: Vikesh <vikeshm@yahoo.com> Para: <php-db@lists.php.net> Enviada em: domingo, 1 de outubro de 2000 20:37 Assunto: [PHP-DB] MySQL and DATE display problem > I'm sure this is a simple query.. but I'm new to PHP > and MySQL: > > I have a db where one field holds the date. As you > all probably know the date is stored in the following > way: > > YYYY/MM/DD > > when I query the db from an html form and PHP, the > result also gets posted in this way (ie YYYY/MM/DD) > > How do I get the date to display in the following > format: > > DD/MM/YYYY? > > all help appreciated. > > Vikesh. > > __________________________________________________ > Do You Yahoo!? > Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! > http://photos.yahoo.com/ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >