Outputting POSIXt in R recipes

Highlighted
UserBird 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
Alex_Combessie Dataiker
Dataiker
Re: Outputting POSIXt in R recipes
Hello,

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

Cheers,

Alexandre
0 Kudos
Labels (3)