Product Documentation

FairCom Database Engine Partitioned Files

Previous Topic

Next Topic

Partitioning by Windows Date Values

The previous date partition rule was implemented for a Unix time value (epoch 1 Jan 1970) and was based on a key value type of double (float).

This revision introduces a modification to the kprawno() function to interpret the first 8 bytes of the partition key value as a Windows local file time timestamp (that is, the timestamp contains the number of 100-nanosecond intervals since January 1, 1601). This option is useful when an application uses the .NET DateTime.ToFileTime() method to generate the timestamp values that are used in the partition key.

Internally, this support converts Windows format to Unix format for flexibility in the partition logic. As a result, it is only enabled for Windows compiles and allows for both formats to potentially be used.

TOCIndex