DB2日期查询

create_time是表字段 timestamp类型，按照年查找：

select substr(char(create_time),1,10) from CMBC_BUDGET_BUSINESS_DETAILS where substr(char(create_time),1,4) = '2018'