Mysql - 从unix时间戳中选择年份

2022-01-13 00:00:00 timestamp select mysql

我正在使用这个:

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;

不记得最后一个问题是否只与 GROUPings 相关:S

Can't remember whether the last issue is only relevant to GROUPings :S

相关文章