In C# code I want to do a date comparison against a column is the database.

Something like:

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

Thanks.