STR_TO_DATE Conversion in mysql

Question

I made this query which select the date in column, now i want to get the year only from selected date .

SELECT column_Name
FROM table_name
WHERE column_name = STR_TO_DATE( '00/00/0000', '%m/%d/%Y' )

Please solve this problem.

Answer 1

The ans of this unclear question should be

SELECT YEAR(STR_TO_DATE( '00/00/0000', '%m/%d/%Y' )) as date from table_name

you should get help fron it

http://dev.mysql.com/doc/refman/5.0/en/date-calculations.html

Answer 2

Try this,

SELECT * FROM table_name WHERE YEAR(column_name) = 2012