hi
I need to calculate the duration difference between 2 dates and having the result in seconds
The field "Debut chargement Profile" correspond to the beginning and the field "Fin chargement Profile" correspond to the end
the timestamp format is the following :
13/09/2021 11:00:06,000
how to do this please?
| eval diff=strptime('Fin chargement Profile',"%d/%m/%Y %H:%M:%S,%Q")-strptime('Debut chargement Profile',"%d/%m/%Y %H:%M:%S,%Q")
| eval diff=strptime('Fin chargement Profile',"%d/%m/%Y %H:%M:%S,%Q")-strptime('Debut chargement Profile',"%d/%m/%Y %H:%M:%S,%Q")
many thanks