如果再不行, 就创建一个格式化函数：ts_fmt，内容如下：
create function ts_fmt(TS timestamp, fmt varchar(20)) \
returns varchar(50) \
return \
with tmp (dd,mm,yyyy,hh,mi,ss,nnnnnn) as \
( \
select \
substr( digits (day(TS)),9), \
substr( digits (month(TS)),9) , \
rtrim(char(year(TS))) , \
substr( digits (hour(TS)),9), \
substr( digits (minute(TS)),9), \
substr( digits (second(TS)),9), \
rtrim(char(microsecond(TS))) \
from sysibm.sysdummy1 \
) \
select \
case fmt \
when 'yyyymmdd' \
then yyyy || mm || dd \
when 'mm/dd/yyyy' \
then mm || '/' || dd || '/' || yyyy \
when 'yyyy/dd/mm hh:mi:ss' \
then yyyy || '/' || mm || '/' || dd || ' ' || \
hh || ':' || mi || ':' || ss \
when 'nnnnnn' \
then nnnnnn \
else \
'date format ' || coalesce(fmt,' <null> ') || \
' not recognized.' \
end \
from tmp
然后可以执行：
db2 => select * from t where col2 = ts_fmt((current timestamp - day(current date) day), 'yyyymmdd')
ID COL2
----------- --------
2 20100430
1 record(s) selected.
db2 =>
这个应该支持低版本的db2.
这个跟
