[R] order list of date (bug?)

rob vech rob.vech87 at gmail.com
Thu Jan 19 20:18:12 CET 2017


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]]



More information about the R-help mailing list