How to group fields and convert time to readable format?

[_Raj]

My task is like I need to group by two fields i.e  eventid and dest  make it happened at  firsttime and lasttime   

eventid      dest                                    count                firsttime                                     lasttime 

256             drdydyf.google.com    56                  2022-09-28T19:21:10             2022-09-28T19:21:34  

249               bigdaddy.com         78                         2022-09-28T19:22:10              2022-09-28T19:22:20

[richgalloway]

Is those the current results or the desired results?  Is the former then what are the desired results?  What do you mean by "readable"?  ISO8601 is perfectly readable, IMO.  What format do you want.