MySQL-从Unix时间戳中选择年份 [英] Mysql - selecting year from a unix timestamp
本文介绍了MySQL-从Unix时间戳中选择年份的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用这个:
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
"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
这篇关于MySQL-从Unix时间戳中选择年份的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文