How to format a date field in MYSQL

Question

Everything,

I need to get the date in a specific format in MYSQL. For instance,

it should return month / year (10/2009).

My version is MYSQL 5.1.

Thanks, Srinivasan.

Answer 1

Function DATE_FORMAT

DATE_FORMAT(col,'%m/%Y') 

Answer 2

Check the documentation for this function in MySQL

DATE_FORMAT (date, format)

 DATE_FORMAT(col, '%m/%Y') 

Answer 3

 date_format(yourdatefield, '%c/%Y') as formatted_date 

will do it - http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

Answer 4

For IIS, I just use the function:

 FUNCTION mySLQDate(xdate) IF xdate <> "" THEN mySLQDate = year(xdate) & "/" & month(xdate) & "/" & day(xdate) END IF END FUNCTION 

Answer 5

use function DATE_FORMAT

http://www.mysqlformatdate.com helps you use the function correctly