Date Datetype and Timezone


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…


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!