Mysql - 从 unix 时间戳中选择年份
我正在使用这个:
SELECT FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year FROM table_name WHERE year = 2009;
但它给了我一个错误:
Unknown column 'year' in 'where clause'SELECT FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year FROM table_name WHERE year = 2009
my_unix_timestamp_column"和table_name"都是正确的,我不知道为什么它给了我这个!!!
Both "my_unix_timestamp_column" and "table_name" are correct, i dont know why it gives me this!!!
我使用的是 PHP 5.3.0
I'm using PHP 5.3.0
推荐答案
我不太确定这是因为 YEAR
是 MySQL 中的保留字,还是因为它想让你做某事大致如下:
I'm not quite sure whether this is due to YEAR
being a reserved word in MySQL or because it wants you to do something along the lines of:
SELECT
FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year
FROM
table_name
WHERE
FROM_UNIXTIME(my_unix_timestamp_column, '%Y') = 2009;
不记得上一期是否只与GROUP
ings 相关 :S
Can't remember whether the last issue is only relevant to GROUP
ings :S
相关文章