Outputting POSIXt in R recipes
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
Hello,
When outputting a data.frame or a data.table in R recipes, columns inheriting of the POSIXt class (POSIXct, POSIXlt) are written as strings. I find this not very consistent, they should be written as dates.
For now the only way I found to do this was to force the dataset schema manually to a date, and write with :
dkuWriteDataset(df, name, schema = FALSE)
I'm using DSS version 4.1.5 and I am writing to a PostgreSQL database.
Did I miss something ? Is there another way to do it ?
Answers
-
Hello,
This is indeed the preferred solution to write R data.frames with specific date types.
Cheers,
Alexandre
