You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "mdianjun (via GitHub)" <gi...@apache.org> on 2024/09/11 02:36:28 UTC
[I] Provide date extracting functions dedicated for PostgreSQL time data type [arrow]
mdianjun opened a new issue, #44054:
URL: https://github.com/apache/arrow/issues/44054
### Describe the enhancement requested
We use arrow compute module to implement execution engine to replace PostgreSQL's, and there are some compute functions to extract year, month and day from the DATE or TIMESTAMP data type in PG table. However, we found that that arrow epoch date is '1970-01-01',and PG epoch date is '2000-01-01', which results in incorrect result when querying PG's DATA or TIMESTAMP data:
```
# create table t1 (x date);
# insert into t1 values('2000-01-01');
# select date_part('year', x) as year from t1;
year
------
1970
(1 row)
```
We want several compute functions dedicated for extracting PG's time data type, the function names can be 'pg_year', 'pg_month', 'pg_day' corresponding to 'year', 'month', 'day', respectively.
### Component(s)
C++
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [C++][Compute] Provide date extracting functions dedicated for PostgreSQL time data type [arrow]
Posted by "thisisnic (via GitHub)" <gi...@apache.org>.
thisisnic commented on issue #44054:
URL: https://github.com/apache/arrow/issues/44054#issuecomment-3921265621
This issue has been closed because there has been no activity for the 14 days since the stale warning. Feel free to reopen if this has been closed in error.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [C++][Compute] Provide date extracting functions dedicated for PostgreSQL time data type [arrow]
Posted by "thisisnic (via GitHub)" <gi...@apache.org>.
thisisnic closed issue #44054: [C++][Compute] Provide date extracting functions dedicated for PostgreSQL time data type
URL: https://github.com/apache/arrow/issues/44054
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [C++][Compute] Provide date extracting functions dedicated for PostgreSQL time data type [arrow]
Posted by "thisisnic (via GitHub)" <gi...@apache.org>.
thisisnic commented on issue #44054:
URL: https://github.com/apache/arrow/issues/44054#issuecomment-3547509120
This issue has been marked as stale because it has had no activity in the past 365 days. Please remove the stale label or comment below, or this issue will be closed in 14 days. If this improvement is still desired but has no current owner, please add the 'Status: needs champion' label.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org