Format Date Process Plugin

FormatDate converts the given timestamp field value to the desired date format. The current version of the plugin only converts the log_ts and col_ts timestamp fields.

The plugin uses the SimpleDateFormat class of JAVA programming language. The SimpleDateFormat class defines the following pattern letters:

Letter	Date or Time Component	Presentation	Examples
`G`	Era designator	Text	`AD`
`y`	Year	Year	`1996`; `96`
`Y`	Week year	Year	`2009`; `09`
`M`	Month in year	Month	`July`; `Jul`; `07`
`w`	Week in year	Number	`27`
`W`	Week in month	Number	`2`
`D`	Day in year	Number	`189`
`d`	Day in month	Number	`10`
`F`	Day of week in month	Number	`2`
`E`	Day name in week	Text	`Tuesday`; `Tue`
`u`	Day number of week (1 = Monday, ..., 7 = Sunday)	Number	`1`
`a`	Am/pm marker	Text	`PM`
`H`	Hour in day (0-23)	Number	`0`
`k`	Hour in day (1-24)	Number	`24`
`K`	Hour in am/pm (0-11)	Number	`0`
`h`	Hour in am/pm (1-12)	Number	`12`
`m`	Minute in hour	Number	`30`
`s`	Second in minute	Number	`55`
`S`	Millisecond	Number	`978`
`z`	Time zone	General time zone	`Pacific Standard Time`; `PST`; `GMT-08:00`
`Z`	Time zone	RFC 822 time zone	`-0800`
`X`	Time zone	ISO 8601 time zone	`-08`; `-0800`; `-08:00`

Release Details

Version:3.0.0

Release date:2018-07-11

Document date:2018-07-12

Supported On:LogPoint v6.0.0 and later

SHA 256: a2f70be7e4f526d5210fc0bfb7936f9d176826af0d05b621022948f56bc387e1

Download

Package Details

Usage Information

Syntax: | process format_date(<timestamp_field>, <date_format>) as <attribute_name>

For example, the "| process format_date(log_ts, "Y G-MM-dd HH w hh:mm:ss Z") as formatted_log_ts" query converts the log_ts (log generation timestamp) field into the Y G-MM-dd HH w hh:mm:ss Z format and stores the result in the formatted_log_ts field.

Installation

Follow these steps to install the FormatDate Process Plugin v3.0.0:

Download the FormatDate Plugin package provided above in the Download section.
Install the package by importing the pak file to LogPoint under Settings >> System >> Applications.

Support

If you have any queries or require assistance, please feel free to contact our support team:

Email: servicedesk@logpoint.com

Phone: +45 7060 6100

Best regards,