java - How to use current date in a sql query of Db2 -
i need query insert current date in sql query. below query works when in db2.
select * h1ti1.ps_cal_detp_tbl  end_dt='2000-02-25' ur;   i need put current date following  end_dt = current_date .
and want use count function count how many rows result.
thanking in advance.
select count(*) h1ti1.ps_cal_detp_tbl  end_dt = current date ur;   count count rows end_dt equal current date(db2 has built in function).
Comments
Post a Comment