[
https://issues.apache.org/jira/browse/CASSANDRA-4628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13450719#comment-13450719
]
Michael Krumpholz commented on CASSANDRA-4628:
----------------------------------------------
yeah, as i wrote in the issue description, in the schema_columns table it is a
DateType class, data type in the create statement is timestamp as it is and
should be in the jdbc context.
> CQL/JDBC: date vs. timestamp issues
> -----------------------------------
>
> Key: CASSANDRA-4628
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4628
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 0.8.0
> Reporter: Michael Krumpholz
> Assignee: Michael Krumpholz
> Priority: Minor
> Labels: cql, jdbc
> Fix For: 1.2.0 beta 1
>
>
> Cassandra's datatypes only have one Date/Time type named timestamp containing
> both date and time. Calling the validator
> org.apache.cassandra.db.marshal.DateType might be OK in general but can be
> confusing in the jdbc context where there is a distinction between date, time
> and timestamp. In terms of jdbc there should be more datatypes for dates and
> times or the jdbc driver should take one of the following options:
> - stick to timestamp
> - check if the date has a time part and distinguish by the data between date
> and timestamp automatically
> - use distinct datatypes according to the jdbc spec, the types would need to
> be in cassandra then too
> Now back to my actual problem:
> org.apache.cassandra.cql.jdbc.JdbcDate returns Types.DATE in getType(). Even
> if having inserted a complete date with time (making it a timestamp) the
> ResultSetMetaData.getColumnType() implementation still returns Types.DATE
> (source of this is in JdbcDate). If some other java code (where i don't have
> access to) uses the metadata to get the type and then getDate() to get the
> value the time is cut off the value and only the date is returned.
> But the ResultSet.getObject() implementation returns a complete
> java.util.Date including the time.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
