Hello guys!
I can not get the output 201101 with this query in MySql:
I hope your help.Code:mysql> SELECT MAKEDATE(YEAR(CURDATE())-1,1) input ,CONCAT(YEAR(MAKEDATE(YEAR(CURDATE())-1,1)),MONTH(MAKEDATE(YEAR(CURDATE())-1,1))) output; +------------+--------+ | input | output | +------------+--------+ | 2011-01-01 | 20111 | +------------+--------+ 1 row in set
Saludos!![]()



Reply With Quote
Bookmarks