Ksqldb iso8601 datetime format return null

Hello i have varchar column with datetime.

its utc


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

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



try with format and again null

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.