Mysql - selecting year from a unix timestamp

Question

I am using this:

SELECT FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year FROM table_name WHERE year = 2009;

but it gives me an error:

Unknown column 'year' in 'where clause'SELECT FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year FROM table_name WHERE year = 2009

Both "my_unix_timestamp_column" and "table_name" are correct, i dont know why it gives me this!!!

I'm using PHP 5.3.0

user_9600987 · Answer

I haven't tried it myself, but would this work?

SELECT YEAR(my_unix_timestamp_column) AS 'year'
FROM table_name
WHERE YEAR(my_unix_timestamp_column) = 2009;