Timezone casting support

I’m just starting to test Build 1.0.1 and quickly noticed that there is currently no support for casting timestamps to alternate time zones. This is something we frequently use in pgsql when rendering data for display to users.

Should I file this as a bug or feature request?

Example query:
select now() at time zone ‘America/New_York’;

Error: XX000
Msg: unimplemented at or near "EOF"
select now() at time zone ‘America/New_York’

Hi @leonardb,

Thanks for the report! Always helpful for us to learn which of Postgres’s many features are actually used. Could you file this on GitHub so we can better track it?

For what it’s worth, this falls into the feature request category since we’re properly returning an “unimplemented” error. But it doesn’t much matter! You should feel free to file GitHub issues for bug reports and feature requests alike.

https://github.com/cockroachdb/cockroach/issues/16382 filed

1 Like