[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