5,891
社区成员




select cast((current date -day(current date)+1 days) as varchar from sysibm.sysdummy1;
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