Converting and useing Netezza Performance Server temporal values

A special encoding format is used to store date, time, and interval values in the user data tables. Your user-defined functions and aggregates might need to parse or compute these temporal fields, so Netezza Performance Server offers a data type helper API that you can use within your C++ source files. Data type helper API reference describes the data type helper API routines that you can use; the sample UDX code in this publication also includes examples that use these API routines.

In addition to the date/time conversion functions, there are several numeric conversion functions that are also available. These functions are also described in Data type helper API reference.