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.
