sql - how to get records who is reaching todays date -


i want records reach todays date in 2 days projectenddt. want show projects going end in 2 days. want show 2 days before.

query

select projectenddt        , projectrenewaldt         , projectupgradedt   tbl_project  convert(varchar(10), dateadd(day, 2, projectenddt)) >= convert(varchar(10), getdate());  

Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -