Github user gabrielreid commented on the pull request:
https://github.com/apache/incubator-phoenix/pull/26#issuecomment-42192917
I think that Timestamp is the only applicable JDBC type that is appropriate
for this kind of function -- it's the only thing that represents a specific
point in time, which is what's needed here.
The fact that Timestamp is larger than desired for a value in the row key
is an application-specific issue that (probably) shouldn't play too much of a
role in defining the API for the function. However, I think there are ways
around this -- for example, assuming that the intention is to get the time
offset at midnight of the given date, I think you could just cast the date
values to timestamps in your SQL statements.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
