Group by Time Feature

The Group by time feature allows using a datetime field as the grouping attribute in a Zoomdata chart. In Zoomdata, when a user selects a time field as the grouping field they are presented a choice of granularities: second, minute, hour, day, week, month, quarter, year. The EDC connector must be able to support all of these groupings. The CreateDBSQLTemplate shows how to implement the required datetime operations to support the group by time feature.