I want to select records with a time stamp of (now - n*hours). I'm using D3 and Paradox tables. Here's what I've done that doesn't work:
q is tquery
lastplay is tdatetime
n is integer
q.SQL.Add('select * from tracks where lastplay < :param');
q.ParamByName('param').AsDateTime := now - n/24;
what am i missing? it must be something simple.