c# - What is a good algorithm to manipulate a lot of DateTime Records? -


i have sql server table in form of

data,startdatetime,enddatetime 

and means sensor has state of data in duration of startdatetime , enddatetime. have lots of these data. there algorithm or class or way query (in c# level or sql level) can ask in specific time sensor state?

in sql if want data instance '2015-08-16 17:33:45'

select data your_table '2015-08-16 17:33:45' between startdatetime , enddatetime 

Comments

Popular posts from this blog

php - Admin SDK -- get information about the group -

dns - How To Use Custom Nameserver On Free Cloudflare? -

Python Error - TypeError: input expected at most 1 arguments, got 3 -