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
|
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,
Comments
Article is closed for comments.