I'm trying to write a query but stuck at beast mode. Can anyone help me with writing 'First day of the current year' in beast mode?
Thank you.
This is one way to do that:
str_to_date(concat(year(curdate()),'-01-01'),'%Y-%m-%d')