由于您的subdateshow是VARCHAR列,而不是正确的DATE,TIMESTAMP或DATETIME列,因此必须在使用YEAR之前将字符串转换为日期:
SELECT YEAR(STR_TO_DATE(subdateshow, "%m/%d/%Y")) from table
参见http://dev.mysql.com/doc/refman/5.5/en/date-and-time- functions.html#function_str-to- date
MySQL从日期格式中提取年份
由于您的subdateshow是VARCHAR列,而不是正确的DATE,TIMESTAMP或DATETIME列,因此必须在使用YEAR之前将字符串转换为日期:
SELECT YEAR(STR_TO_DATE(subdateshow, "%m/%d/%Y")) from table
参见http://dev.mysql.com/doc/refman/5.5/en/date-and-time- functions.html#function_str-to- date