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

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -