Dates in PHP-MYSQL
Posted: Thu Apr 25, 2002 7:59 pm
how do you change the date from MYSQL's YYYY-MM-DD to lets say March 3 or so? 
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$date1 = date("j/m/Y");I would definitely recommend going with the MySQL date formatting over the PHP formatting. This is not to say anything against PHP's really cool date formatting functions, but rather as a means of increasing your script's performance.Ruiser wrote:Check out http://www.mysql.com/doc/D/a/Date_and_t ... tions.html. Scroll down until you reach the DATE_FORMAT() function.