Date Transformation

The Date transformation plugin is available in the Hub.

This transformation takes a date in either a unix timestamp or a string, and converts it to a formatted string. 

Configuration

Property

Macro Enabled?

Description

Property

Macro Enabled?

Description

Source Field Name

Yes

Required. The field (or fields separated by commas) that contain the date to format. 

Source Field Date Format

Yes

Optional. The SimpleDateFormat of the source fields. If the source fields are longs, this can be omitted. For examples, see the Java SimpleDateFormat documentation. 

Source in Seconds or Milliseconds?

No

Optional. If the source fields are longs, you can indicate if they are in seconds or milliseconds.

Default is Milliseconds.

Target Field Name

Yes

Required. The field (or fields separated by commas) that contain the date to write to in the output schema.

Target Field Date Format

Yes

Optional. The SimpleDateFormat of the output field. For examples, see the Java SimpleDateFormat documentation. 

Created in 2020 by Google Inc.