cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benedict (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-6350) Timestamp-with-timezone type
Date Wed, 02 Apr 2014 16:05:16 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-6350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13957824#comment-13957824
] 

Benedict commented on CASSANDRA-6350:
-------------------------------------

You're more talking about: [datetimeoffset|http://msdn.microsoft.com/en-us/library/bb630289.aspx]
in SQL Server, which lets you store the timezone along with the value.

> Timestamp-with-timezone type
> ----------------------------
>
>                 Key: CASSANDRA-6350
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6350
>             Project: Cassandra
>          Issue Type: Wish
>          Components: Core
>            Reporter: Ramkumar S
>            Priority: Minor
>              Labels: lhf
>
> Create a table with a timestamp column.
> Insert a value from US time Zone.
> Try querying the value from a different time zone like India.
> The timestamp column  value shown in the select query result is converted to Indian Local
time instead of showing the actual value.
> This becomes a problem when we want to narrow down the query using where condition.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message