Community Conundrum 25: Feature Visualization is now live! Read More

Outputting POSIXt in R recipes

Dataiker
Dataiker
Outputting POSIXt in R recipes

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 ?

0 Kudos
1 Reply
Dataiker
Dataiker
Hello,

This is indeed the preferred solution to write R data.frames with specific date types.

Cheers,

Alexandre
0 Kudos
Labels (3)