Displaying 1 result from an estimated 1 matches for "sizectrl".
Did you mean:
sizecl
2010 Mar 24
2
translating SQL statements into data.table operations
...o
at a loss at whether I can express the remainder using data.table's
%between% operator or not.
ctqm <- sqldf("SELECT e.*,
c.DATE 'DATEctrl',
c.TIME 'TIMEctrl',
c.PRICE 'PRICEctrl',
c.SIZE 'SIZEctrl'
FROM edt e, ctq c
WHERE e.SYMBOL = c.SYMBOL AND
julianday(e.DATE) - julianday(c.DATE) BETWEEN 15 AND
75 AND
strftime('%H:%M:%S',c.TIME) BETWEEN
strftime('%H:%M:%S',e.BEGTIME) AND strftime('%H:...