Db2 Developer-C 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (
  id int,
  txdtdbvl numeric(8),
  ggdtmsug numeric(8)
);
insert into t (id, txdtdbvl, ggdtmsug) values (1, 20240415, 20240101);
insert into t (id, txdtdbvl, ggdtmsug) values (2, 20240415, 20241225);
insert into t (id, txdtdbvl, ggdtmsug) values (3, 20241208, 20241225);
with
p (cd) as (
  select 
    year(CURRENT DATE) * 10000 + month(CURRENT DATE) * 100 + day(CURRENT DATE) 
  from sysibm.sysdummy1
)
select *
from t, p
where txdtdbvl between
  trunc(greatest(p.cd, t.ggdtmsug) / 100) * 100 + 01 and
  trunc(greatest(p.cd, t.ggdtmsug) / 100) * 100 + 31;


ID
TXDTDBVL
GGDTMSUG
CD


1
20240415
20240101
20240425

3
20241208
20241225
20240425