Target table with data applied 1 second later than specified in the "stop post at sourcetime" command (4222503)

Target table column with systimestamp datatype displays that data was applied 1 second later than specified in the "stop post at sourcetime" command.

Example:

On Target the following post command was issued:

sp_ctrl> stop post at sourcetime HH:MM:SS   ----> Example 12:00:00

sp_ctrl> stop post at sourcetime 12:00:00  

The target table column with datatype "systimestamp" shows that data posted 1 second later  ----> example 12:00:01

In other words, select from the target table shows that the data was posted one second later than specified in the "stop post at sourcetime" command.

WORKAROUND:

Change target column datatype from systimestamp to sysdate.