Dates are lower by 1

[Thordin]

date.fromtimestamp is supposed to take a local timestamp not a UTC one. I am in a timezone that is behind UTC, so all dates are 1 day behind.

>>> datetime.date.fromtimestamp(0)
datetime.date(1969, 12, 31)

To fix this you need to use datetime.datetime.utcfromtimestamp().date() instead.

clickhouse-driver/src/columns/datecolumn.py

Line 18 in a3a2651

return date.fromtimestamp(value * self.offset)

return datetime.datetime.utcfromtimestamp(value * self.offset).date()

[xzkostyan]

Fixed: dcfe640.

This change will be in next release.

[Thordin]

That's great, did you take a look at another fix I proposed here?

#20

[xzkostyan]

Hi, @Thordin

Version 0.0.10 is released. Should we close this issue?