I have a list with tick objects including a pair of a double value and a timestamp.
I want to separate the list into child-lists depending on a time interval (for example 15 minutes). One list only has the tick objects from: 8:00:00 – 8:14-59 usw usw
var result = from tick in listTicks group tick by tick.timestamp.Hour;
datetime functions like day, hour, minute work fine but a specific interval wasn't possible for me.
It is LINQ to objects. I have already got the list from the DB and I want to transform the list.
If I have data from 8-22 each day separate to 3 h he separate this way:
var result = from tick in listTicks group tick by (tick.timestamp.Day * 10 + tick.timestamp.Hour / 3);
I want it to separate it this way.
Fixed: DateTime.Now will cause issues :)
Bug notice: Wont work with LINQ2SQL
Fix: Left to reader :)