Shifts timestamps by a random amount of a specific unit of time within a set range.
For date-only values, the Timestamp Shift Generator supports the following date formats. The example values are all for February 23, 2021.
MM/dd/yyyy - 02/23/2021
MM/dd/yy - 02/23/21
MM-dd-yyyy - 02-23-2021
yyyyMMdd - 20210223
yyyy/MM/dd - 2021/02/23
MMddyyyy - 02232021
Consistency
Yes, can be made self-consistent or consistent with another column.
Linking
No, cannot be linked.
Differential privacy
No
Data-free
No
Allowed for primary keys
No
Allowed for unique columns
No
Uses format-preserving encryption (FPE)
No
Privacy ranking
3 if not consistent
4 if consistent
Generator ID (for the API)
To configure the generator:
From the Date Part dropdown list, select the unit of time to use for the minimum and maximum shift.
In the Minimum Shift field, type the minimum amount the value can be shifted from the original value.
Use negative numbers to indicate to shift the date to the past.
For example, assume that the date part is Day. -3 indicates that the day cannot be shifted earlier than 3 days before the original day. 3 indicates that the date cannot be shifted earlier than 3 days after the original day.
In the Maximum Shift field, type the maximum amount by which the value can be shifted from the original value.
For example, assume that the date part is Day. 5 indicates that the date cannot be shifted later than 5 days after the original day.
Toggle the Consistency setting to indicate whether to make the generator consistent. By default, consistency is disabled.
If you enable consistency, then by default the generator is self-consistent. To make the generator consistent with another column, from the Consistent to dropdown list, select the column. When a column is consistent with itself, then the same date part value is always shifted by the same amount.
When a column is consistent with another column, then for the same value in the other column, the date part value is always shifted by the same amount. For example, for the same value of username, the birthdate column value is always shifted by the same amount.
If multiple columns that use the Timestamp Shift generator are consistent with the same other column, then for those columns, the date part value shifts by the same amount. For example, the startdate and enddate columns are both consistent with the username column. Both startdate and enddate use the Timestamp Shift generator. For the same value of username, both startdate and enddate are shifted by the same amount.
If Structural data encryption is enabled, then to use it for this column, toggle Use data encryption process to the on position.