N
If you have SQL Server 2008+, you can convert it to DATE:SELECT TOP 2000 a.UserID,
a.CharName as maton,
a.DeadCharName as Victima,
b.[level] as nivel_de_Victima,
COUNT(a.DeadCharName) as Veces,
CONVERT(DATE,a.actiontime) ActionTime
FROM PS_GameLog.dbo.Kill_Log a
INNER JOIN PS_GameData.dbo.Chars b
ON a.CharID = b.CharID
WHERE a.CharID = 62336
GROUP BY a.UserID,
a.CharName,
a.DeadCharName,
b.[level],
CONVERT(DATE,a.actiontime)
ORDER BY Veces DESC;
If not, you can convert it to a string that contains only the year, month and day:SELECT TOP 2000 a.UserID,
a.CharName as maton,
a.DeadCharName as Victima,
b.[level] as nivel_de_Victima,
COUNT(a.DeadCharName) as Veces,
CONVERT(VARCHAR(8),a.actiontime,112) ActionTime
FROM PS_GameLog.dbo.Kill_Log a
INNER JOIN PS_GameData.dbo.Chars b
ON a.CharID = b.CharID
WHERE a.CharID = 62336
GROUP BY a.UserID,
a.CharName,
a.DeadCharName,
b.[level],
CONVERT(VARCHAR(8),a.actiontime,112)
ORDER BY Veces DESC;
