The encodeDate (time_t Values) function
The encodeDate() function converts a
time_t Date value to a Netezza-encoded Date. The function drops the hours, minutes, and seconds
elapsed after the last whole day in the time_t value to round the
time_t value down to the last whole day.
The encodeDate (struct tm Values) function
Converts a struct tm value to a Netezza-encoded Date. The function uses tm.tm_year, tm.tm_mon and tm.tm_day
fields of date only, and ignores the other fields. The date value should
pass the isValidTimeStruct boolean test, but it is not a requirement.
The encodeTime() function
The encodeTime() function converts a
h:m:s:micros Time value to a Netezza-encoded Time value.
The encodeTimestamp (time_t Input Format) function
Converts a time_t value to a Netezza-encoded Timestamp. Encodes the value in UTC and applies no offsets.
It also adds zero microseconds to the encoded value.
The encodeTimestamp (struct tm Input Format) function
Converts a struct tm value to a Netezza-encoded Timestamp. The function uses only the tm.tm_year, tm.tm_day,
tm.tm_mon, tm.tm_hour, tm.tm_min and tm.tm_sec fields of the ts structure,
and ignores the rest. The ts structure must pass the isValidTimeStruct() boolean
test. The function also adds zero microseconds to the encoded value.
IBM PureData System for Analytics, Version 7.1