[thelist] PHP/MySQL Date Format Help

[Hassan Schroeder]

Rob Smith wrote:

> ever worked with php/mysql and the date format, you've probably seen the
> format like YYYY-MM-DD. 

> Can anyone offer a more cleaver way to reformat the YYYY-MM-DD into
> DD-MM-YYYY. Strangely enough I think I see the answer:

   SELECT DATE_FORMAT(myDateColumn, "%d-%m-%Y") FROM myTable;

Let the DB take care of the "cleaver" stuff :-)

-- 
Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                           dream.  code.