RisingWave Community - How can I convert a Kafka timestamp to a timestamp format in SQL?

RisingWave Community

risingwave-community.slack.com

troubleshooting

How can I convert a Kafka timestamp to a timestamp format in SQL?

Rahul is looking for a way to convert a Kafka timestamp to a timestamp format in SQL. Bohan provided a suggestion for explicitly casting the Kafka timestamp to a timestamp format.

Rahul Biju

Asked on Aug 23, 2023

To convert a Kafka timestamp to a timestamp format in SQL, you can explicitly cast the Kafka timestamp.

SELECT _rw_kafka_timestamp::timestamp FROM StudDemo6

Aug 23, 2023Edited by