This works for Postgresql:
select count(*) from mdl_user where
mdl_user.lastaccess > (date_part('epoch'::text, now())::bigint - 300);
or
select firstname,lastname from mdl_user where
mdl_user.lastaccess > (date_part('epoch'::text, now())::bigint - 300)
order by 2,1;
Comments
Comments powered by Disqus