Do you want to keep only the first day of the quarter?

WITH flash_date_table as (Select * from unnest(GENERATE_DATE_ARRAY("2024-01-07", DATE_ADD(CURRENT_DATE(),INTERVAL 1 QUARTER), INTERVAL 1 QUARTER)) as flash_date)

SELECT *  from 
Test.staff_time # your table with column date: cal_date
right join
flash_date_table
on cal_date=flash_date
WHERE cal_date>="2024-01-07"