FME Transformers: 2024.1

Categories
Calculated Values
Database
Strings
Related Transformers
DateTimeCalculator
DateTimeRounder
DateTimeStamper

DateTimeConverter

Converts a set of input date/time attributes from one format to another, in place.

Jump to Configuration

Typical Uses

  • Converting dates and times between formats

How does it work?

The DateTimeConverter can be used to convert date/time values into Standard FME Date/Time Format, and convert standard FME date/time values in a destination format.

The input can contain a date, a time (with or without UTC offset), a datetime (with or without UTC offset), or a Unix epoch time.

Converting Multiple Attributes

Multiple attributes can be selected for conversion in the Datetime Attributes parameter.

If all attribute values are successfully converted, the feature exits via the Output port.

If any values fail conversion, the feature is rejected, and output via the <Rejected> port. However, all requested attributes are still processed and any successfully converted values will be present in the rejected feature.

Note  Input Format and Output Format presets can be used for date/time validation. For example, by setting both input and output format strings to "FME", non-FME datetime values will be rejected by DateTimeConverter. Repair Overflow allows leap seconds and other overflow parts to be rolled forward.

Usage Notes

Configuration

Input Ports

Output Ports

Parameters

Editing Transformer Parameters

Transformer parameters can be set by directly entering values, using expressions, or referencing other elements in the workspace such as attribute values or user parameters. Various editors and context menus are available to assist. To see what is available, click beside the applicable parameter.

For more information, see Transformer Parameter Menu Options.

Reference

Processing Behavior

Feature-Based

Feature Holding

No

Dependencies None
Aliases

DateConverter

DateFormatter

DateParser

DateTimeFormatConverter

DateTimeFormatter

DateTimeParser

DateTimeValidator

DateValidator

History  

FME Community

The FME Community is the place for demos, how-tos, articles, FAQs, and more. Get answers to your questions, learn from other users, and suggest, vote, and comment on new features.

Search for all results about the DateTimeConverter on the FME Community.