topic Re: Convert from UNIX Time to a timezone in Español

Convert from UNIX Time to a timezone

Anonymous — Sun, 03 Apr 2016 19:04:00 GMT

Recently, I have to work with a system that stores time in UNIX format. In UNIX systems time is represented as the number of seconds that have elapsed since January 1st, 1970 00:00:00 (UTC). After doing some research I found out how to translate this numbers into timestamp:

Timestamp = UnixTime / 86400 + 25569

For instance, If you want to convert unix time 1405688400 into timestamp, you have to use the following expression:

The resulting timestamp is in UTC. In case that you need to convert this time to another timezone ConvertToLocalTime can be used. For instance if you want to convert to PST time:

Hope this helps.

Regards,

Karla.

Re: Convert from UNIX Time to a timezone

Joaquin_Lazaro — Mon, 04 Apr 2016 13:32:29 GMT

Hola Karla:

Si haces la conversión durante el script evitarás recalcular todas las TS en cada click

Saludos

Joaquín

Re: Convert from UNIX Time to a timezone

Anonymous — Sun, 17 Apr 2016 21:07:27 GMT

Hola Joaquinlr,

Gracias por la sugerencia, y si en efecto lo hicimos hace un par de dias. Tuvimos que extraer la data de una central telefonica para analizar el trafico de llamadas, e hicimos la conversion a nivel de scripting y tener disponible el valor de timestamp ya calculado en la visualizacion.

Saludos Cordiales,

-- Karla

Re: Convert from UNIX Time to a timezone

Joaquin_Lazaro — Mon, 18 Apr 2016 06:32:40 GMT

Perfecto Karla.

Como creaste un blog no sé si puedes marcar la respuesta como útil y correcta, Siempre ayuda a los compañeros a filtrar sus búsquedas

Saludos

Joaquín