Grouping by a Timestamps Date in SQL statement

villegasi03 — Thu, 27 Oct 2011 14:30:48 GMT

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

topic Grouping by a Timestamps Date in SQL statement in QlikView

Grouping by a Timestamps Date in SQL statement