RisingWave Community - Should the validation allow specifying a time zone for `now()` in a query for creating a materialized view?

RisingWave Community

risingwave-community.slack.com

troubleshooting

Should the validation allow specifying a time zone for `now()` in a query for creating a materialized view?

I tried to explicitly set the timezone in a query for creating a materialized view, but it resulted in an error. Should the validation allow specifying a time zone for now() in a query, or will that break something else?

Mark Needham

Asked on May 07, 2023

The validation should allow specifying a time zone for now() in a query for creating a materialized view.
However, adding a timezone clause directly to now() may violate the types of filters allowed with now().
To avoid this issue, it is recommended to create the timestamp column in the table as timestamptz instead of timestamp to handle time zones effectively.

May 09, 2023Edited by