The "lubridate" package will help simplify these time zone conversions. It 
provides two simple functions with_tz and force_tz that conceptually make 
things simpler.

library(lubridate)
> x <- as.POSIXct("2015-06-22 01:53:28", 'Europe/Berlin')
> with_tz(x, 'America/Toronto')
[1] "2015-06-21 19:53:28 EDT"

HTH,

J

-----Original Message-----
From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Ronny Steen
Sent: Sunday, November 22, 2015 2:52 AM
To: r-help@r-project.org
Subject: [R] Converting time zones in R using metadata file information of 
video files, help needed.

Hi,

I have video files (FAT) that are taken in a different timezone than my current 
location. The modification date/time in the metafila data of the video file 
shows the time video was taken, although in the current timezone of my 
computer, if I understand right.

I wish to convert the date/time to the origin. The video was taken in London, 
Ontario Canada at 2015-06-21 07:53:28, when looking at the metadata of the file 
on my computer (timezone "Europe/Berlin") it says modification date "2015-06-22 
01:53:28". Hence, there is a 6 hour difference between the two time-zones

I use the script provided here:
http://blog.revolutionanalytics.com/2009/06/converting-time-zones.html

pb.txt <- "2015-06-22 01:53:28" #modification date as shown on my computer 
(timezone
"Europe/Berlin")

pb.date <- as.POSIXct(pb.txt, tz="Europe/London")

pb.date <- as.POSIXct(pb.txt, tz="America/Toronto")#timezone of origin video 
camera location

format(pb.date, tz=local.time,usetz=TRUE) #formats the mtime to data and time 
when the video was taken

[1] "2015-06-22 07:53:28 CEST" # the time is correct but the date is wrong as 
it has added 6 hours rather than subtracting.

I find working with different time-zones to be difficult, I hope I managed to 
formulate an understandable question.

Regards,

Kes

        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to