dateInt是一个整数某天,
SELECT dateInt, date
IF(dateIntIS NULL,NULL,
date_format( CONCAT(date_format(date,'%Y-%m-'),dateInt) ,"%Y-%m-%d")
) FROM 表
IF(date IS NULL,NULL, 值)
CONCAT("abc","def")
date_format(str,"%Y-%m-%d"))
dateInt是一个整数某天,
SELECT dateInt, date
IF(dateIntIS NULL,NULL,
date_format( CONCAT(date_format(date,'%Y-%m-'),dateInt) ,"%Y-%m-%d")
) FROM 表
IF(date IS NULL,NULL, 值)
CONCAT("abc","def")
date_format(str,"%Y-%m-%d"))