Version

    Current date and time

    Current date and time writes current date and time into designated column. Same value will be written into each row in dataset.

    Parameters

    • Target column: required, configure the column which will receive the current date and time. Output will always be of date type.

      • Write result to the current column: overwrite the input column with the result.

      • Create new column with name: create a new column with specified name. Name of the new column can contain spaces or special characters - technical column name will be created automatically. The new column will be placed right after the input column.

    Examples
    Output value Description

    2023-03-06 12:34:16.285

    Current date and time
    Remarks

    • The step will return the same value for each row in the data set regardless of how long the job execution takes. The value written is the date and time when the Wrangler job was started.

    • The value returned is with millisecond precision.

    See also