You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Jun 22, 2025. It is now read-only.
Oleg V. Kozlyuk edited this page Sep 14, 2022
·
4 revisions
ClickHouse.Client tries to correctly handle timezones and DateTime.Kind property. Specifically:
DateTime values are returned as UTC. User can then convert them themselves or use ToLocalTime() method on DateTime instance
When inserting, DateTime values are handled in following way:
UTCDateTimes are inserted 'as is', because ClickHouse stores them in UTC internally
LocalDateTimes are converted to UTC according to user's local timezone settings
UnspecifiedDateTimes are considered to be in target column's timezone, and hence are converted to UTC according to that timezone
For columns without DateTime specified, client timezone is used by default (legacy behavior). UseServerTimezone flag in connection string can be used to use server timezone