查询时date和timesamp做比较条件解决办法

查询时date和timesamp做比较条件
SELECT * FROM CARDRECORD AS cardcord LEFT JOIN CARD ON CRCDID=CDID WHERE cardcord.CRCDID='NO1202020002' AND cardcord.CRSTATUS='0' AND cardcord.CRDATE<=CARD.CD_ENABLE_DATE2


cardcord.CRDATE为TIMESAMP

CARD.CD_ENABLE_DATE2为DATE


DB2里有函数进行转换吗


如果有的话在IBATIS里面写SQL语句时能否直接使用


[解决办法]

SQL code

SELECT * FROM CARDRECORD AS cardcord      LEFT JOIN CARD ON CRCDID=CDID WHERE cardcord.CRCDID='NO1202020002'  AND cardcord.CRSTATUS='0'  AND cardcord.CRDATE<=cast(CARD.CD_ENABLE_DATE2 as timestamp)