Epoch time to Time date convert

[emhatek]

Dear All,
my channel is connected to the OPC DA that contain the epoch value. however we want to display it as time date format.
Does anyone success to create formula that can convert the epoch time to time date format.
please advise if any.

thanks & regards
Emha

• This topic was modified 3 months, 4 weeks ago by emhatek.

[manjey73]

What is time in Epoch format ?
Are you talking about Unix Time?

• This reply was modified 3 months, 4 weeks ago by manjey73.

[manjey73]

https://stackoverflow.com/questions/249760/how-can-i-convert-a-unix-timestamp-to-datetime-and-vice-versa

[manjey73]

And in order to convert DateTime to the channel value, you need to add DateTime.ToOADate()

[Mikhail]

Hi,

@emhatek, what version of Rapid SCADA do you use?

[emhatek]

Hi Manjey,
thanks for your reply,
epoch mean UNIX timestamp value in UTC.
OPC channel value type is epch unix, and will be displayed in the HMI page in datetime format.

[emhatek]

Hi Mikhail,
my rapid scada is V6

[emhatek]

Dear All,
currently i’m success to convert UNIX time to datetime format as Manjey Advice. below my formula that add to scrip database.

public static double UnixTimeStampToDateTime(double unixTimeStamp)
{
    // Unix timestamp is seconds past epoch
    DateTime dateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc);
    dateTime = dateTime.AddSeconds( unixTimeStamp );
    return dateTime.ToOADate();
}

[Mikhail]

Also possible

dateTime = DateTimeOffset.FromUnixTimeSeconds((long)unixTimeStamp).ToUniversalTime();

[emhatek]

Hi Mikhai,
let me try and thanks for your advise.

[Author]

Posts