Outputting POSIXt in R recipes

[UserBird]

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 ?

[Alex_Combessie]

Hello,

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

Cheers,

Alexandre