关于db2条件查询中的to_date问题

Question

select a from t where b = '0' and to_date(c,'yyyy-mm-dd HH24:MI:SS') >= to_date('2016-01-05 00:00:00','yyyy-mm-dd HH24:MI:SS') and d = '9' order by e desc
执行出错，我上网查了下，改成了
select a from t where b = '0' and values to_date(c,'yyyy-mm-dd HH24:MI:SS') >=values to_date('2016-01-05 00:00:00','yyyy-mm-dd HH24:MI:SS') and d = '9' order by e desc
还是报错，求大神指点。
刚刚直接select a from t where to_date(c,'yyyy-mm-dd HH24:MI:SS') >= to_date('2016-01-05 00:00:00','yyyy-mm-dd HH24:MI:SS')还是错误的

Answer 1

问题已解决。。。正确格式是：
(values to_date(c,'yyyy-mm-dd HH24:MI:SS') )>= (values to_date('2016-01-05 00:00:00','yyyy-mm-dd HH24:MI:SS'))