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.

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

timestamp and precision #1207

Closed
williamstein opened this issue Feb 7, 2017 · 1 comment
Closed

timestamp and precision #1207

williamstein opened this issue Feb 7, 2017 · 1 comment

Comments

@williamstein
Copy link

The TIMESTAMP data type in postgreSQL by default has 6 digits after the decimal point.
If you store this time in PostgreSQL via some method:

2017-02-07T19:53:43.242999

then read it back with this node-postgres driver, you'll get

2017-02-07T19:53:43.242

I.e., the driver textually truncates the last 3 digits, rather than rounding to the nearest millisecond.

This bug (or very bad design decision) caused me a large amount of pain recently...

@charmander
Copy link
Collaborator

See #1200.

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

No branches or pull requests

2 participants