In C# code I want to do a date comparison against a column is the database.
select someColumn from someTable
where CurrentDate-someDate > ElapsedTimeColumn
I want to get the currentdate in C# and run a query from my application.
How do i get the format of:
mm/dd/yyyy hh:ss:mm AM/PM