We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
get
show
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Presently, show timezone does not work:
show timezone
DataFusion CLI v11.0.0 ❯ show time zone; NotImplemented(“SHOW time.zone not implemented. Supported syntax: SHOW <TABLES>“)
Describe the solution you'd like
Instead, I would like:
show timezone;
To always return 'utc'.
set timezone 'utc';
Should succeed.
set timezone 'UTC+08`;
should return an error.
and
set timezone 'US/Mountain`;
should return the same error.
This should:
PS:
Do the same for select current_setting('TIMEZONE')
select current_setting('TIMEZONE')
Describe alternatives you've considered
timestamp without timezone
The text was updated successfully, but these errors were encountered:
@andygrove @waitingkuo @alamb @tustvold
Sorry, something went wrong.
For what it is worth, here is what postgres does (mostly what @avantgardnerio has proposed). Note there is an = in SET TIMEONE='';
=
SET TIMEONE=''
psql (14.4) Type "help" for help. alamb=# show timezone alamb-# ; TimeZone ------------------ America/New_York (1 row) alamb=# set timezone='UTC+08'; SET alamb=# show timezone; TimeZone ---------- UTC+08 (1 row) alamb=# set timezone='US/Mountain'; SET alamb=# show timezone; TimeZone ------------- US/Mountain (1 row)
(the proposal in this ticket sounds good to me)
Statement::ShowVariable
Nice work @waitingkuo , thank you!!
Successfully merging a pull request may close this issue.
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Presently,
show timezone
does not work:Describe the solution you'd like
Instead, I would like:
To always return 'utc'.
Should succeed.
should return an error.
and
should return the same error.
This should:
PS:
Do the same for
select current_setting('TIMEZONE')
Describe alternatives you've considered
timestamp without timezone
The text was updated successfully, but these errors were encountered: