I'm using a CSV export, but can't get the dates & time to display correctly. Is there an easy solution that I'm missing?
I assume this is because the two programs use two different date formats, but I can't seem to deduce an easy way to convert from one to the other.
If you're exporting CSV from Wireshark (File > Export Packet Dissections > As CSV...), rather than using -T fields etc. in TShark, then it's exporting the columns of the packet summary; if you specify the time format as "date and time of day" (View > Time Display Format > Date and Time of Day), then the CSV export will show the date and time as YYYY-MM-DD HH:MM:SS.SSSSSS.
According to this Stack Overflow question's current topmost answer:
For second accuracy, yyyy-MM-dd HH:mm:ss should do the trick.
I believe Excel is not very good with fractions of a second (loses them when interacting with COM object IIRC).
which suggests that the ".SSSSSS" part of that might be an issue, but that YYYY-MM-DD HH:MM:SS, at least, should work.
Comments