[jira] [Comment Edited] (ARROW-17132) [R] Timezone handling in round-trip of POSIXct

["Dragoș Moldovan-Grünfeld (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARROW-17132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17569074#comment-17569074 ] 

Dragoș Moldovan-Grünfeld edited comment on ARROW-17132 at 7/20/22 3:00 PM:
---------------------------------------------------------------------------

Without having looked into it, I think Neal's suggestion might do the trick. 

Moreover, in the chunk above, I don't think {{tz = "UTC"}} is being used by {{as.Date()}}, but rather silently ignored.


was (Author: dragosmg):
Without having looked into it, I think Neal's suggestion might do the trick. 

> [R] Timezone handling in round-trip of POSIXct
> ----------------------------------------------
>
>                 Key: ARROW-17132
>                 URL: https://issues.apache.org/jira/browse/ARROW-17132
>             Project: Apache Arrow
>          Issue Type: Bug
>          Components: R
>            Reporter: Rok Mihevc
>            Priority: Minor
>              Labels: test
>
> The following:
> {code:r}
> df <- tibble::tibble(
>   time = as.POSIXct(seq(as.Date("1999-12-31", tz = "UTC"), as.Date("2001-01-01", tz = "UTC"), by = "day"))
> )
> compare_dplyr_binding(
>   .input %>%
>     mutate(x = yday(time)) %>%
>     collect(),
>   df
> )
> {code}
> Fails with:
> {code:bash}
> Failure (test-dplyr-funcs-datetime.R:574:3): extract wday from timestamp
> `object` (`actual`) not equal to `expected` (`expected`).
> `attr(actual$time, 'tzone')` is a character vector ('UTC')
> `attr(expected$time, 'tzone')` is absent
> Backtrace:
>  1. arrow:::compare_dplyr_binding(...)
>       at test-dplyr-funcs-datetime.R:574:2
>  2. arrow:::expect_equal(via_batch, expected, ...)
>       at tests/testthat/helper-expectation.R:115:4
>  3. testthat::expect_equal(...)
>       at tests/testthat/helper-expectation.R:42:4
> {code}
> This also happens for qday and probably other functions where input is temporal and output is numeric.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)