Ksqldb iso8601 datetime format return null

Hello i have varchar column with datetime.

its utc

|2022-02-09T13:27:17.165116Z
|2022-02-09T13:27:27.3850848Z
|2022-02-09T13:28:18.5537284Z  

on select query parse as by standart but return ‘null’ for all rows:

PARSE_TIMESTAMP(entrydate, 'yyyy-MM-ddTHH:mm:ss.SSSZZZZ')

code:

JsonSerializer.Serialize(DateTime.UtcNow);

try with format and again null
'YYYY-MM-DDTHH:mm:ss.SSSZ'

I believe this has been answered here. The solution is copied here for reference:

This is because ksqldb only supports up to millisecond precision see https://www.confluent.io/blog/ksqldb-2-0-introduces-date-and-time-data-types/

There is a github issue tracking support for finer time resolution like microseconds here Support microseconds for TIMESTAMP type · Issue #8243 · confluentinc/ksql · GitHub

1 Like

and what can do now ? wait fix?

This topic was automatically closed after 30 days. New replies are no longer allowed.