ksqldb returning TIMESTAMP in wrong format. #10638
Description
If a stream/table has a TIMESTAMP column, and the REST API'S /query will return with JSON reporting it as a timestamp.
This is a string value, and is of the wrong format. As per https://docs.confluent.io/platform/current/ksqldb/reference/sql/data-types.html:
...it needs to map to java.sql.Timestamp.
E.g, there can be a "T" separator in there, so it is NOT compatible with java.sql.Timestamp despite what the documentation says. But the response contains it. E.g., "1970-01-01T03:25:43.335".
Shouldn't it be impossible?
Example response:
{"queryId":"transient_TICKET_SALES_6527111408917527410","columnNames":["PURCHASER_NAME","MOVIE_TITLE","TICKET_DATE","SHOWTIME","PURCHASE_TIMESTAMP","LOCATION"],"columnTypes":["STRING","STRING","DATE","TIME","TIMESTAMP","STRING"]}
["Alice","blah","2003-10-20","00:00:12","1970-01-01T03:25:43.335","location"]