SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference result for sessiontimezone between SQLCL and SQL*PLUS

Kevin ZhangFeb 23 2023

I issue the command “SELECT sessiontimezone from dual” again same database using SQLCL and SQL*PLUS and result has some difference.

Database: 19c

SQLCL Version: 22.4

SQL*PLUS Version: 21.0

SQLCL V22.4:

==> it returns my session timezone region value “America/Chicago” from database

SQL*PLUS 21.0

==> it returns my session timezone's UTC offset value

In my case, I prefer UTC offset value. what I can do to force SQLCL return UTC offset value?

Thanks!

Kevin

This post has been answered by user9540031 on Feb 24 2023

Jump to Answer

Added on Feb 23 2023

1 comment

65 views