Inserting aware Datetime returns an error.

[MarkRatFelt]

I'm trying to insert some DateTime data to CrateDB, but I'm getting an error.

The datetime I'm trying to insert looks so:

The column is a Timestamp with time zone column.

But I get this error:

  File "/Users/chuckaguilar/PycharmProjects/postgres-cratedb-migration-tool/venv/lib/python3.7/site-packages/crate/client/http.py", line 82, in default
    delta = o - self.epoch
TypeError: can't subtract offset-naive and offset-aware datetimes

But the CrateJsonEncoder (self.epoch) is naive:

tzinfo is None

So... it won't work. Either I make my datetime naive, or the self.epoch gotta be aware.

[MarkRatFelt]

It'd work converting it to a string via datetime.strftime("%Y-%m-%dT%H:%M:%S.%f%z")

thanks, @autophagy :)

[chaudum]

Related to crate/sqlalchemy-cratedb#92

[amotl]

Hi there,

apologies for the late reply. insert_basic.py#L43-L44 demonstrates that this problem has been resolved by one of the recent releases. The driver now accepts inserting both timezone-aware and naive Python datetime objects.

With kind regards,
Andreas.