Happy New Year Everyone,
I’m hoping to set the timeframe for my windowjoin to start at 9:30 instead of time - interval:
w: (0;0)+:table `timestamp;
As is above, it will give me a start/end time of the timestamp. I’m hoping to make it so that the start time is 9:30 and the end time is whatever is in the list of timestamps from the table.
Thanks!
Hi, it sounds like you need something along the lines of
q)t:(sym:3#ibm;time:10:01:01 10:01:04 10:01:08;price:100 101 105)<br>q)w:flip 09:30:00,/:ttime
q)w
09:30:00 09:30:00 09:30:00
10:01:01 10:01:04 10:01:08
You would need to tailor it to your actual timestamp datatype (if type timestamp then you’d need to include the date with the 09:30 but that shouldn’t be too hard to achieve).
Terry