Hi Andrei, I got this to work by setting the server and client time zones to be the same.
So what happened was that I had created the table and inserted the record using Sqlline.sh on the server host. That must have stored the effective_date field in the key based on the server's time zone (UTC). Then when I queried the key from the client code, which was running on a host in a different time zone (UTC-5:00), it probably generated the same field from the local time zone. I should have known that Timestamp type is zone specific. Thank you, Yong -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/