Naveen(PHP/MySql/Ajax/ExtJs)
This blog contains information regarding PHP,HTML, CSS, AJAX, JQUERY AND EXTJS.
Monday, April 12, 2010
How to use DATE_FORMAT() in mysql
$query = "SELECT DATE_FORMAT(DATETIME,'%m/%d/%Y') as NewDate,id FROM TableName ORDER BY DATETIME DESC";
result:
month(numeric)/day(numeric)/year(numeric)..
cheers :)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment