iq库 sql语句问题，高手帮忙看看，谢谢！

Question

这个可以查询出来
select cast(dateformat((cast ('20190427140000' as timestamp) -1.0/24),'yyyymmddHH') as int);
但做为查询条件却报错。
select * from A_FT_ST_FNET_CITY_H a where a.HOUR_KEY=cast(dateformat((cast ('20190427140000' as timestamp) -1.0/24),'yyyymmddHH') as int);

报错信息如下：

[Error] Script lines: 2-2 --------------------------
SQL Anywhere Error -1001006: Data exception - data type conversion is not possible.
-- (dflib/dfe_Cast.cxx 840)
Msg: 21, Level: 14, State: 0
Line: 0

Answer 1

HOUR_KEY字段的类型是什么？