kacaii.dev / senac-brigade-server
wip: currently rewriting the project as a full stack application tangled.org/kacaii.dev/sigo
gleam
fork atom
senac-brigade-server / src / app / domain / occurrence / sql / query_recent_occurrences.sql
at main 11 lines 291 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1--  Find all occurrences from the last 24 hours 2select 3 o.id, 4 o.created_at, 5 o.description, 6 o.occurrence_category, 7 o.occurrence_subcategory, 8 o.occurrence_location, 9 o.reference_point 10from public.occurrence as o 11where o.created_at >= (now() - '1 day'::interval);