Transaction timestamp with punctuation - Connect_CDC - connect_cdc_mimix_share - Latest

Method:   Transaction timestamp with punctuation

Function name:   trantimepunc

Parameter list: none

Return type:    CHAR

What the method does: The implied input is the current data row.    For log-based Change Selectors, returns the transaction commit timestamp. Time is GMT, including fractions of a second.

For a trigger-based Change Selector, returns the time of the transaction’s last update captured for replication.

“trantimepunc” should be used if the target column is a timestamp. The format is:

yyyy-mm-dd hh:mm:ss.ffffff

and, therefore, is suitable for mapping to timestamp/date/time columns in addition to character columns.

The source of this data is not a column but a field in the log record or the time recovered from a stored procedure and is always maintained as a character string.

If a Copy request, sends a zero-length string. To see an example of how to code an expression to return a different value than the default, see  Code row optype to return a value other than a zero-length string and Code row timestamp to return a value other than a zero-length string.