Does StarRocks have 1. toStartOfMonth https://clickhouse.com/docs/sql-reference/functions/date-time-functions#toStartOfMonth or 2. toStartOfInterval https://clickhouse.com/docs/sql-reference/functions/date-time-functions#toStartOfInterval Basically, given a datetime, return the beginning of the month,

select toStartOfMonth(now());

   ┌─toStartOfMonth(now())─┐
1. │            2025-10-01 │
   └───────────────────────┘

use

date_trunc('month', now());