Date Datetype and Timezone

Hi,

I am a little confuse about Date datetype. Basically,

If no timezone set, insert will save as UTC., select will show UTC.
If session timezone is set, insert will save as local time , but select is still in UTC.

I’ve open a ticket, but I am not sure if this is a bug or I am not using Date datatype correctly. Can anyone please give me a little help here?

Thank you very much…

https://github.com/cockroachdb/cockroach/issues/17199

Leo

Hi Leo! Thanks for your inquiry, and sorry for the late answer. We’ll be continuing this discussion on the Github issue you’ve created. Thanks again!