WeBlog — блог про веб-программирование

SELECT CONCAT( IF(10>DAY(date),"0",""),DAY(date),".",IF(10>MONTH(date),"0",""),MONTH(date)) as date
FROM table_name

где поле date — это дата в mysql-вском формате

This entry was posted on Saturday, April 18th, 2009 at 11:01 pm and is filed under Базы данных. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.