Time Stamp conversion

[mrmike]

Does anyone know how to automagically convert Unix time stamp to real time. I'm trying to get datamining php to work for the IP accounting 1.0 I downloaded from star-os files. I finally got all the other aspects working, but have stumbled on this problem

Thanks

[butchkemper]

In Perl, use the "localtime" function.

In Excel, this formula will work:

=(x+y)/86400+DATE(1970,1,1)

x is the unix timestamp and y is the offset in seconds from UTC

Butch