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.