SELECT CONVERT(varchar,created_at ,5) as [DD-MM-YY], count(*)<br>FROM ordenes o<br>where CONVERT(varchar,created_at ,5) = '20-11-2020'<br>GROUP BY CONVERT(varchar,created_at ,5) order by CONVERT(varchar,created_at ,5) desc;SELECT CONVERT(varchar,created_at ,5) as [DD-MM-YY], count(*) FROM ordenes o group by CONVERT(varchar,created_at ,5) order by CONVERT(varchar,created_at ,5) desc;https://www.sqlshack.com/es/funciones-y-formatos-de-sql-convert-date/
#fechas