(date_trunc does not exist) MySql Workbench, Can someone please help solving this error

Viewed 10
select date_trunc('week', events.occured_at),
        count(distinct events.user_id) as weeklyactive_users
from events 
where events.event_type = 'engagement'
and events.event_name = 'login'
group by 1
order by 1;

Error Code: 1305. FUNCTION case_study_2.date_trunc does not exist -- here case_study_2 is database Can someone tell what this error is?

0 Answers
Related