[
https://issues.apache.org/jira/browse/METAMODEL-198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14962955#comment-14962955
]
ASF GitHub Bot commented on METAMODEL-198:
------------------------------------------
Github user kaspersorensen commented on the pull request:
https://github.com/apache/metamodel/pull/59#issuecomment-149125641
I made a mistake in my research! Somehow got the impression that 1
nanosecond = 1000 microsecond. But it's in deed the other way around! Then the
strange rounding issue that I saw makes absolute sense because PostgreSQL's
rounding to the nearest 1000 nanos is exactly 1 microsecond! :-)
I guess I just need to then update the JdbcTestTemplates class to also
support Microsecond precision.
> Where clauses on timestamp loses the nanoseconds
> ------------------------------------------------
>
> Key: METAMODEL-198
> URL: https://issues.apache.org/jira/browse/METAMODEL-198
> Project: Apache MetaModel
> Issue Type: Bug
> Reporter: Ankit Kumar
>
> Queries having where clause on timestamp column in databases loses the
> nanoseconds.
> This is happening because the Timestamp values are converted to Date object
> using the new Date(long timeInMilliseconds).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)