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