0 comments

Mysql query for date format

Published on Tuesday, April 6, 2010 in

if you wanted to change the format of a MySQL date from YYYY-MM-DD to MM/DD/YYYY or DD/MM/YYYY format you can use the DATE_FORMAT() function as shown in the example below:

SELECT DATE_FORMAT(field name, '%d/%m/%Y') FROM tablename

SELECT DATE_FORMAT(column_name, '%m/%d/%Y') FROM tablename

Spread The Love, Share Our Article

Related Posts

Posted by Anuraj S at 7:00 AM
Labels:

No Response to "Mysql query for date format"

Post a Comment

Subscribe to: Post Comments (Atom)