Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sub query postgres

select id, ten_minute_interval
from (
  select to_timestamp(floor((extract('epoch' from CREATED_AT) / 600 )) * 600) as ten_minute_interval
  , id
  from TABLE_NAME
) as nested
where ten_minute_interval >= 'TIMESTAMP'
 
PREVIOUS NEXT
Tagged: #query #postgres
ADD COMMENT
Topic
Name
4+5 =