cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alok Dwivedi <alok.dwiv...@instaclustr.com>
Subject Re: how to store date before > 1970
Date Fri, 12 Apr 2019 08:15:16 GMT
You should be able to use timestamp or date for dates before 1970. Here is an example
CREATE TABLE test_ts_date (id int, ts timestamp, dt date, value text, PRIMARY KEY (id, ts));
 
INSERT INTO test_ts_date (id, ts, dt, value) VALUES (1, '2019-04-11 01:20:30', '2019-04-11',
'value1');
INSERT INTO test_ts_date (id, ts, dt, value) VALUES ( 1, '2014-02-12 03:15:30', '2014-02-12',
'Value3');
INSERT INTO test_ts_date (id, ts, dt, value) VALUES ( 1, '1960-02-12 05:25:33', '1960-02-12',
'Value1 for ts before 1970');
INSERT INTO test_ts_date (id, ts, dt, value) VALUES ( 1, -2522680400000, '1890-22-01', 'Value2
for negative ts');

select * from test_ts_date ;

 id | ts                              | dt         | value
----+---------------------------------+------------+---------------------------
  1 |                  -2522680400000 | 1890-01-22 |    Value2 for negative ts
  1 | 1960-02-12 05:25:33.000000+0000 | 1960-02-12 | Value1 for ts before 1970
  1 | 2014-02-12 03:15:30.000000+0000 | 2014-02-12 |                    Value3
  1 | 2019-04-11 01:20:30.000000+0000 | 2019-04-11 |                    value1


You can choose either of timestamp or date based on what precision you want. They both can
take values before 1970. I think there might be issue sending negative long for timestamps
from Java driver (I haven’t tried that) but passing dates before 1970 should be fine. Some
related tickets for reference. 
https://datastax-oss.atlassian.net/browse/JAVA-264 <https://datastax-oss.atlassian.net/browse/JAVA-264>
https://datastax-oss.atlassian.net/browse/JAVA-313 <https://datastax-oss.atlassian.net/browse/JAVA-313>

Thanks
Alok Dwivedi
Senior Consultant 
https://www.instaclustr.com/




> On 12 Apr 2019, at 07:25, adrien ruffie <adriennolarsen@hotmail.fr> wrote:
> 
> Hello all,
> 
> I have a tricky question about "how to store a date" if dates can be a date prior to
1970 ?
> I checked the potential data type and found timestamp and date but both begin to the
epoch (January 1, 1970) ...
> 
> If I want to store oldest dating, which data type and means I can use ?
> 
> Thank you and best regards,
> 
> Adrien


Mime
View raw message