Skip to content
This repository has been archived by the owner on Apr 17, 2018. It is now read-only.

do_postgres appears to be truncating timestamp smaller than seconds #78

Open
tpitale opened this issue Mar 11, 2015 · 1 comment
Open

Comments

@tpitale
Copy link
Member

tpitale commented Mar 11, 2015

https://gist.github.com/tpitale/39e97ef1ca24e968dd35

The transaction_time is a column in PostgreSQL. In that example, I get back the value casted by do_postgres as a DateTime, and missing milliseconds. If I cast in PostgreSQL as a text value, and then simply call to_datetime in Ruby, the milliseconds are still present.

Any idea why this is happening and how to fix it? Thanks!

@tpitale
Copy link
Member Author

tpitale commented Mar 11, 2015

It looks like data_objects_parse_date_time in the C is parsing and truncating at seconds.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant