mysql> SELECT DATE_FORMAT(NOW(), '%d/%m/%Y') as tanggal1, DATE_FORMAT(NOW(), '%M %D, %Y') as tanggal2; +------------+----------------------+ | tanggal1 | tanggal2 | +------------+----------------------+ | 20/09/2010 | September 20th, 2010 | +------------+----------------------+ 1 row in set (0.00 sec)