I need to calculate time between two column. I don't know how to deal with these records which passed mid-night. for example: 2nd and 4th records it started at Jun 21st, end at Jun 22nd.
Thanks in advance for any advice you can provide me
You need to extract each date, convert then in "seconds since 01/01/1970" and make substraction between the two amount of seconds.
Use something like this :
Hello @green_k, on forums we do encourage users to do add their efforts which they have put in order to solve their own problem, so kindly do add the same in your question and let us know then.
date -d "06/21/2020 21:42:24" +%s and got below error:
date: illegal option -- d
usage: date [-u] mmddHHMM[[cc]yy][.SS]
date [-u] [+format]
date -a [-]sss[.fff]
my os is SunOS 5.10 Generic_150400-64 sun4v sparc sun4v