I am hoping that this will be an easy question to answer. I am trying to group some data from a SQL table by date but the table only contains a timestamp.
Below is an example of my script:
LOAD
ID,
EmployeeCt;
SQL Select
ID,
Timestamp,
COUNT(Employee) AS EmployeeCt
FROM dbo.Employees
GROUP By ??????;
Any help would be much appreciated. Thank you