Ksqldb iso8601 datetime format return null

[padavan]

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'

[vnadkarni]

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 ksqlDB 0.20 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

[padavan]

and what can do now ? wait fix?