`DateTime` convertion error

[Olegt0rr]

Statements:

INSERT INTO table VALUES

Values:

[(datetime.datetime(2024, 6, 24, 19, 42, 52, 607030), ..., ]

Exception

aiochclient.exceptions.ChClientError: Code: 6. DB::Exception: Cannot parse string '2024-06-24 19:42:52.607030' as DateTime: syntax error at position 19 (parsed just '2024-06-24 19:42:52'): while executing 'FUNCTION if(isNull(_dummy_0) : 3, defaultValueOfTypeName('DateTime') :: 2, _CAST(_dummy_0, 'DateTime') :: 4) -> if(isNull(_dummy_0), defaultValueOfTypeName('DateTime'), _CAST(_dummy_0, 'DateTime')) DateTime : 1': While executing ValuesBlockInputFormat. (CANNOT_PARSE_TEXT) (version 22.10.2.11 (official build))

Dependencies

python 3.11
aiochclient==2.6.0

Misc

Bug was added after aiochclient>2.4.0

I think it was here:
2168222

[ddsstt]

Same for me here, @Olegt0rr have you managed to find any workarounds?

[girvel]

.replace(microsecond=0) on datetime is a workaround