confluentinc / confluentinc/kafka-tutorials

Questions about ksqlDB timezone tutorial

Open
#875 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
39
Forks
91
PR merge metrics
No merged PRs in 30d

Description

In the [ksqlDB timezone tutorial](https://kafka-tutorials.confluent.io/connect-sink-timestamp/ksql.html#convert-column-to-different-timezone), a new stream is created with a timestamp configured to a specific timezone. Then, a connector sinks this stream to a Postgres DB.

The ability to view the timestamps in a different timezone in ksqlDB makes sense, but when sending this data to Postgres, as far as I understand, it’s just an epoch time being sent, and there’s no timezone information going to the DB. Only ksqlDB is aware of the timezone information. Is that correct? In other words, changing the timezone in ksqlDB isn’t really changing the underlying timestamp value in any way - it’s the same epoch time throughout.

If so, then it might be a good idea to add more narrative to the tutorial to explain this, to avoid any misunderstanding. The impression I got from the tutorial is that it's implying the timezone change made in ksqlDB is propagated to Postgres, but doesn't seem like it actually is.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.