How to extract time and day from date

I have a column name Date in which field is 11/11/2018 11:29 i want to extract this vale 11/11/2018 11:29 into new column time in which
time is 11:29 and day is also coming from new column Day
for example 11/11/2018 is sunday
i write this for new column
mutate {
add_field => {"Time" => "%{Date}"}
then i write

date {
match => ["time","HH:mm:ss"]
locale => en
timezone => "UTC"
but it adds new column time but it shows 11/11/2018 11:29 i want only 11:29 in time. Can someone help me in this really appreciate it..

Also i want a new column day
mutate {
add_field => {"Day" => "%{Date}"}

Now the in the day column i want day just drop from the date field 11/11/2018
which is sunday so my day column will show day and my time column show will show the time and date column which is also present showing full date and time.

something like grok { match => { "date" => "%{DATE:date_only} %{TIME:time_only} } }

i am not extracting from column field for example your payment has been made on 24-10-2018 23:30 i am extracting from column in which only date field i.e TIme 24-10-2018 23:30
is coming if i am extracting from msg field then i will use the grok fileter

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.