RisingWave Community - Is it possible to get the timestamp in the format YYYY-MM-DD HH:MM:SS[.D+{up to 6 digits}] or YYYY-MM-DD HH:MM:SS?

Yes, the default format of _rw_kafka_timestamp in RisingWave is in the format YYYY-MM-DD HH:MM:SS[.D+{up to 6 digits}].
If you are using a materialized view in RisingWave, you can include the _rw_kafka_timestamp in your select query to retrieve the timestamp in the desired format.
Here is an example of including _rw_kafka_timestamp in a materialized view query:

create materialized view mv as select _rw_kafka_timestamp, * from twitter;