How to write first day of current year in Beast Mode

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.

Comments

  • AS
    AS πŸ”΅

    This is one way to do that:

    str_to_date(concat(year(curdate()),'-01-01'),'%Y-%m-%d')