If using a datetime column in SQL Server, various elements can be extracted such as the hour, month or year. The example in this document explains how to extract the hour using the following ApplySimple statement:
ApplySimple("#0", Hour(date))
The attribute definition should now appear as follows:
The following data may also be extracted from a datetime column by replacing the 'Hour' in the ApplySimple, with any of the following:
