DB2日期转换为字符串

 select "EMP_NO", "WORK_DATE", "HOLIDAY", "IN_TIME", "OUT_TIME", "LATE",
    "EARLYOFF", "OVERTIME", "ABSENT", "LEAVE", "LEAVE_HOURS", "MEMO"
  from "DB2INST3"."WORK_RECORD"
  where char(WORK_DATE) like '%2009-11%'
with ur;