select * from A where DATE_FORMAT(START_TIME) <= CURRENT_TIMESTAMP;//查询成功
select * from A where DATE_FORMAT(END_TIME) <= CURRENT_TIMESTAMP;//报错,非法的时间日期类型数据
DB2存的时间类型是VARCHAR,说明END_TIME有数据转为成时间类型时非法,经过筛查,发现有24:00:00这样的数据。
标签:00,END,FORMAT,非法,DATE,日期,TIME,类型,select From: https://www.cnblogs.com/cs-learn/p/17182149.html