FairCom RTG V2 Update Guide

SQL create index logic on date/time fields

FairCom RTG V2 introduced support for creating indexes in SQL over data that sorts properly for SQL. That support did not include fields using a numeric field type that was mapped to date, time, and timestamp SQL fields.

This support includes indexing SQL fields mapped to data with two constraints:

1. Indexing of the underlying actual data type must be supported.
2. The numeric value of the type and its date, time, or timestamp interpretation must sort identically (i.e., dates having a YYYYMMDD format can be sorted but not dates with a MMDDYYYY format).