DateTimeConverterValve

Converts a date/time value from one format to another.

Source value supported formats:

  • ISO instant: 2020-02-03T10:16:16.441Z
  • ISO offset: 2020-02-03T11:30:00.000+01:00
  • ISO local time (no timezone, system default is used): 2020-02-03T11:30:00.000
  • JDBC timestamp: 2020-02-03 11:30:00
  • Custom format specified by property src_format

Output format is by default ISO instant but can be customised using dest_format property.

Conversion can also modify the date/time value using a duration in ISO-8601 duration format PnDTnHnMn.

Properties

Name Description Default value Mandatory Supports property expansion
src The date/time value to convert Yes Yes
src_format The format of the source value No No
src_tz The timezone of the source value (if not included in value) No No
dest The item property (or flow attribute if no items exist) to receive the converted date/time. Yes No
duration Duration to add/remove from the date/time. No No
dest_format Date/time pattern of convertion result ISO instant format No No

Example Configuration

{
    "name":"DateTimeConverterValve",
    "config": {
        "src":"{{item.timestamp}}",
        "src_format": "yyyy/MM/dd HH.mm.ss",
        "dest":"result",
        "duration":"-PT2H",
        "dest_format":"yyyy-MM-dd HH:mm:ss"
    }
}


Requirements