DAYOFYEAR

1
SELECT
2
  event_date,
3
  DAYOFYEAR(event_date) as day_of_year
4
FROM (
5
  SELECT DATE '2024-01-01' as event_date UNION ALL
6
  SELECT DATE '2024-06-15' UNION ALL
7
  SELECT DATE '2024-12-31'
8
);

1
SELECT
2
  YEAR(sale_date) as year,
3
  DAYOFYEAR(sale_date) as doy,
4
  SUM(amount) as daily_sales
5
FROM sales
6
WHERE DAYOFYEAR(sale_date) <= 180
7
GROUP BY YEAR(sale_date), DAYOFYEAR(sale_date)
8
ORDER BY doy, year;

1
SELECT
2
  TODAY() as current_date,
3
  DAYOFYEAR(TODAY()) as current_doy,
4
  ROUND(DAYOFYEAR(TODAY()) * 100.0 / 365, 1) as year_progress_pct;