[Question] Hi everyone!! I am not sure this is the...
# generalf
Fernando Barbosa
06/15/2022, 8:32 PM[Question] Hi everyone!! I am not sure this is the right channel for this but here we go. I need to query for all transactions in the past five minutes from now. I have a column with timestamp in a realtime table. However, I do not know how to express this in the
where Copy code
where timecolumn <= (current_timestamp - interval '5' minute) as BIGINT * 1000Fernando Barbosa
06/15/2022, 8:42 PMI tried this
WHERE timecolumn < now() - 86400000Fernando Barbosa
06/15/2022, 8:42 PMbut no success
m
Mark Needham
06/16/2022, 5:06 AM
do you get an error message?
Mark Needham
06/16/2022, 5:09 AM
Copy code
select count(*)
from pullRequestMergedEvents
where createdTimeMillis > now() - CAST(1000*60*60 AS long)
limit 10✅ 1
Mark Needham
06/16/2022, 5:10 AM
it should work pretty similar to how you have it
🙌 1
f
Fernando Barbosa
06/16/2022, 5:28 AMI do get an error message. I'll try this and get back with the result.
Fernando Barbosa
06/16/2022, 4:38 PMBrilliant!!! Thank you so much! It works!! thankyou