dbplyr icon indicating copy to clipboard operation
dbplyr copied to clipboard

add comments to date translation to clarify non-SQL origins (months(), days() on Postgres + Snowflake)

Open fh-mthomson opened this issue 10 months ago • 0 comments

I found myself confused while trying to trace back date translations in dbplyr to their non-SQL origins, specifically base vs. lubridate functions:

  • months() to lubridate, when the translations actually correspond to base::months()
  • days() to base R (actually corresponds to lubridate::days()

I've proposed minor comments to hopefully prevent this confusion for future folks referencing these backend-specific translations for days() and months() (only available for Postgres and Snowflake - the latter was mirrored from the former).

cc: @fh-afrachioni

fh-mthomson avatar Apr 11 '24 04:04 fh-mthomson