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
Post a Comment