Transform Hour and date

Jelssy_Pomar_Alvan · February 15, 2021, 6:40pm

Hello, I am new to Kibana, I have a Table with 2 columns (dateini and date end) with format "dd / mm / yyyy hh: mm: ss". I need to change this format to "hh: mm: ss" and then do a subtraction of these 2 fields and display them in a metric.

For example: 19:01:00 - 19:00:00 = 1 minute difference

I would appreciate if you can help me.

AClerk · February 16, 2021, 4:27am

You can create a scripted field.

int start = doc['date_filed1'].value.getHour()*3600 + doc['date_filed1'].value.getMinute()*60 + doc['date_filed1'].value.getSecond();
int end = doc['date_filed2'].value.getHour()*3600 + doc['date_filed2'].value.getMinute()*60 + doc['date_filed2'].value.getSecond();
int diff = end-start;
return diff;

This will give you the differences in seconds.

Thanks!

Jelssy_Pomar_Alvan · February 16, 2021, 5:06am

Thanks, but my initial field is a string, how to convert my initial field to a date?

AClerk · February 16, 2021, 5:13am

There are examples in the documentation.
Please read it.