Transaction timestamp - Connect_CDC - connect_cdc_mimix_share - Latest

Method:   Transaction timestamp

Function name:   trantime

Parameter list: none

Return type:    CHAR

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

For log-based servers, returns transaction start timestamp.

The format is:

yyyymmddhhmmssffffff

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.