I have data which has two columns time
and timezone
that have the timestamp of events. Examples are:
time timezone
1433848856453 10800000
It seems like the timestamp has fractional seconds in the information as well. I don't understand the timezone format but it must be an equivalent unix format. I need to preserve the fractional seconds as well. How do I go from that to something like in R?
2015-01-01 13:34:56.45 UTC
Note: This human readable date is not the actual converted values of the unix timestamp shown.
It looks like the
timezone
column is the timezone offset, in milliseconds. I assume that means the timezone column will adjust for daylight saving time manuallySo you should add the
time
andtimezone
columns before converting toPOSIXct
. You should also set thetz
to"UTC"
so no DST adjustments will be made to yourPOSIXct
object.