This worked for me: Select dateadd(S, [unixtime], '1970-01-01') From [Table]. In case any one wonders why 1970-01-01, This is called Epoch time. ... <看更多>

... <看更多>

public static readonly DateTime UnixEpoch = (0L).AsUnixTime();. /// <summary>. /// Converts the number of seconds passed since UTC Unix Epoch to local time. ... <看更多>

This is fairly easy to do using the Field calculator and a simple custom function. The result is a string, which you can coerce to a proper time/date class ... ... <看更多>