Print Page - Convertion of Unix timestamp

Title: Convertion of Unix timestamp
Post by: juga on May 20, 2013, 04:12:52 PM

Hi, I am testing Advanced Serial Data Logger with a serial device that provides through the serial port some values and the timestamp in Unix time format, for example:

1368597301 (Unix time) -----> 2013-05-15 05:55:01

Is it possible to convert this value using the Expressions plug to a regular date and time format (for example YYYY.MM.DD HH:NN:SS) in the parsing process?

Thanks!

Title: Re: Convertion of Unix timestamp
Post by: juga on November 15, 2023, 11:00:00 AM

Hi, I found the solution:

This should be used on the expressions module:

TIME=UNIXTODATETIME(TIME)

Where:

TIME: parsed variable in Unix time format (for example 1368597301)

UNIXTODATETIME: function to convert from unix to regular time expression

Advanced Serial Data Logger is a great application! best regards.

AGG Software Forums

Online Help Center => Data loggers and plug-ins => Topic started by: juga on May 20, 2013, 04:12:52 PM