We are evaluating Cassandra database and found that it always saves the DateTimeoffset in UTC. We have data in different timezones and we need timezone info. I dont want to save timezone in any other field. Is there any way?
EDIT - Additional information.
Here is snippet of code. Saving it as timestamp. Let me know if you need any other details.
CREATE TABLE IF NOT EXISTS Test (bucket int, datetime timestamp, sensor1 text, sensor2 text, PRIMARY KEY(bucket,timestamp)) WITH CLUSTERING ORDER BY (datetime desc);
Insert into Test (bucket, datetime, sensor1, sensor2) values (1, DateTimeoffset.Parse("23-04-2020 10:45:27 +05:30"), '11', '22')
Select * from Test where bucket = 1 and datetime > sometime; 1 2020-04-23T10:45:27.000Z 11 22