Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Convert dates to R native types #24

Closed
thrasibule opened this issue Mar 17, 2015 · 5 comments
Closed

Convert dates to R native types #24

thrasibule opened this issue Mar 17, 2015 · 5 comments
Milestone
1.0

Comments

@thrasibule
Copy link
Contributor

Right now dates types are exported as character. One thing I miss from the RPostgreSQL package is that dates would be converted transparently to R types.
@thrasibule thrasibule mentioned this issue Mar 17, 2015
Closed
@laurikoobas
Copy link

I'd like to see this as well. Took me a good long while to track a failing code down to a different date representation compared to RPostgreSQL. Actually I don't mind the character representation, but I sure missed it being mentioned somewhere :)

@mplourde
Copy link

Additionally, dbWriteTable should properly convert POSIXct/Date columns to Postgres date/time types. Currently, it raises an error.

@Andrei-Pozolotin
Copy link

+1

@jonassundman
Copy link

This would be very nice to have implemented, as.Date conversions in R tend in my experience to be memory intensive.

@krlmlr krlmlr mentioned this issue Oct 27, 2015
Closed
@krlmlr krlmlr added this to the 1.0 milestone Nov 10, 2015
@krlmlr krlmlr closed this as completed in e581d36 Nov 9, 2017
krlmlr added a commit that referenced this issue Nov 9, 2017
@krlmlr
Merge tag 'v0.1-8'
cc596c9 
- Improve DBI compatibility (#24, #41, #52, #53, #61, #62, #70, #79, #104, #121).
- Define `timegm` for Windows and add missing function (#136).
- The time zone is set by executing `SET TIMEZONE='UTC'` instead of setting an environment variable (#136).
krlmlr added a commit that referenced this issue Nov 21, 2017
@krlmlr
improve parametrized queries, closes #24, closes #66
4d0753e
@github-actions
Copy link

github-actions bot commented Dec 8, 2020

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.

@github-actions github-actions bot locked and limited conversation to collaborators Dec 8, 2020
krlmlr pushed a commit that referenced this issue Oct 18, 2022
@IndrajeetPatil
remove rmarkdown bandaid; closes #24
e0624c3
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
1.0
Development

No branches or pull requests
6 participants
@thrasibule @laurikoobas @mplourde @Andrei-Pozolotin @krlmlr @jonassundman