Skip to content

[R][C++] Discussion: Plans for date casting from int to support an origin option? #31240

@asfimport

Description

@asfimport

2 questions:

  • plans to support an origin option for int -> date32 casting?

  • plans to support double -> date32 casting?

    Currently the casting from integer to date works, but assumes epoch (1970-01-01) as the origin. 

    > a <- Array$create(32L)
    > a$cast(date32())
    Array
    <date32[day]>
    [
      1970-02-02
    ]

    Would it make sense to have an origin option that would allow the user to fine tune the casting? For example, in R the base::as.Date() function has such an argument

    > as.Date(32, origin = "1970-01-02")
    [1] "1970-02-03"

    We have a potential workaround in R (once we support date & duration arithmetic), but I was wondering if there might me more general interest for this.

    A secondary aspect (as my R example shows) R support casting to date not only from integers, but also doubles. Would there be interesting in that? Need be I can split this into several tickets.

    Are there any plans in either of these 2 directions?

Reporter: Dragoș Moldovan-Grünfeld / @dragosmg
Watchers: Rok Mihevc / @rok

Related issues:

Note: This issue was originally created as ARROW-15798. Please see the migration documentation for further details.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions