When did the switch between 'summer time'/'winter time' (or 'daylight savings'/'standard') happen in CET last year? (Did 2:35 exist on March 27, 2016?)
At the R level, what is as.numeric(strptime(df$DateTime, format='%Y-%m-%d %H:%M:%S')) with your time zone settings? Bill Dunlap TIBCO Software wdunlap tibco.com On Thu, Jan 19, 2017 at 11:18 AM, rob vech <rob.vec...@gmail.com> wrote: > Hi list, > I'd like to submit the following problem that seems a bug but it is so > strange that it could be my mind ... so > I would like to sort a list of date time items like in this script: > > df = data.frame(DateTime = c( > '2016-12-21 10:34:54', > '2016-12-21 11:04:54', > '2016-12-21 11:34:54', > '2016-03-27 02:05:50', > '2016-03-27 02:35:50', > '2016-12-21 12:04:54', > '2016-12-21 12:34:54' > )) > > df$DateTime = as.POSIXlt(strptime(df$DateTime, format='%Y-%m-%d %H:%M:%S')) > > ord = order(as.numeric(strptime(df$DateTime, format='%Y-%m-%d %H:%M:%S'))) > > df.ord = df[ord,1] > df.ord > > I have the following results: > > "2016-12-21 10:34:54 CET" > "2016-12-21 11:04:54 CET" > "2016-12-21 11:34:54 CET" > "2016-12-21 12:04:54 CET" > "2016-12-21 12:34:54 CET" > "2016-03-27 02:05:50" > "2016-03-27 02:35:50" > > the last two terms should be before (note that CET is missing). > > if I change "2016-03-27 02:05:50" and "2016-03-27 02:35:50" to something > like "2016-03-27 01:05:50" and "2016-03-27 01:35:50" > it seems to work. It seems to have problem with 02 hours. Any ideas? > I'm using R-3.1.2 on Win > Thank you > rob > > [[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.