Convert date in epoch time to date format

support
1

In database have a field with epoch time. Is here any way to convert into date format over xslt transformation ?
For example:
In database is 1632129694 and need show for user as 20.9.2021 9:21:34.

2

Solution : AS:AddSeconds('1970-01-01T00:00:00', 1632129694)

3

And is there any impact from the differences in time zones or daylight saving time?

4

AS:AddSeconds returns server’s local time with the corresponding time zone.

@JiriPrajz so is your number a Unix Timestamp?

5

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.

6

I dont know. I know only that Name of field is

<UTCStartingTimeS>1632129694</UTCStartingTimeS>

I suppose that it is UTC Epoch time.

7

I guess it’s a Unix Epoch.