[datatable-help] problems with adding a DateTime column
Chris Neff
caneff at gmail.com
Thu Mar 8 17:22:11 CET 2012
Try as.IDate around your strptime. strptime returns POSIXlt which
isn't really amenable to data tables (or frames for that matter). In
base R you would usually convert to POSIXct, but IDate is integer
based and made to be able to key on dates in data.tables.
On Thu, Mar 8, 2012 at 11:11 AM, Alexander Peterhansl
<APeterhansl at gaincapital.com> wrote:
> 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
>
>
>
>
>
>
> _______________________________________________
> datatable-help mailing list
> datatable-help at lists.r-forge.r-project.org
> https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
More information about the datatable-help
mailing list