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