[datatable-help] problems with adding a DateTime column
Alexander Peterhansl
APeterhansl at GAINCapital.com
Thu Mar 8 17:11:25 CET 2012
Dear Datatable-Help:
I'm running R version 2.14.1 and data.table 1.7.10 (on Windows 7 and Linux). On both systems I get a strange result in the following toy example:
test <- data.table(A=c(1,2,3))
test[,B:= c("2011-01-01","2011-01-02","2011-01-03")]
test[,C:= strptime(c("2011-01-01","2011-01-02","2011-01-03"),format="%Y-%m-%d")]
Output:
A B C
[1,] 1 2011-01-01 0, 0, 0
[2,] 2 2011-01-02 0, 0, 0
[3,] 3 2011-01-03 0, 0, 0
Columns A and B show the expected behavior. Column C was supposed to simply convert the date strings into DateTime types. Clearly this is not happening.
Please help.
Regards,
Alex
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20120308/208b9d00/attachment.html>
More information about the datatable-help
mailing list