CODESYS Forge - CODESYS Forge / Talk / Engineering 🇬🇧: log .csv timestamp

log .csv timestamp

Forum: Engineering 🇬🇧

Creator: xawme88

Created: 2020-11-10

Updated: 2020-11-10

xawme88 - 2020-11-10

Hi,

I don't understand the date-time (timestamp) column of the .csv log file from CodeSYS runtime system.

I attach an example of file generated 2020/11/10 10:53 h but the timestamp data is not valid or I don't understand it. The date-time from device log using the developement system is ok.

Thanks.

PlcLog.csv

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

kislov - 2020-11-10

Seems like it's Unixtime, but in µs instead of typical ms (maybe because: <timestamp>rtc high resolution</timestamp> ?)

So you need divide value by 1000 and convert with Unixtime converter.

For example:

01605001540799 / 1000 = 1605001540.8 =~ 1605001540

https://www.unixtimestamp.com/index.php

👍
2

Last edit: kislov 2020-11-10

10-11-2020 19-26-18.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Morberis - 2020-11-10
  
  Great explanation.
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- xawme88 - 2020-11-10
  
  Great! Thank you very much!
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.