more SQL question using PIVOT, no aggregation column December 19, 2021June 14, admin I would like to do a PIVOT on my table but I don’t have aggregation column. SELECT CONVERT(date, DataHora) AS dia, CONVERT(VARCHAR(5), DataHora, 108) AS hora FROM Read More