Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sessiontimezone variable in Oracle

Status
Not open for further replies.
cmmrfrds

cmmrfrds

Programmer
Feb 13, 2000
4,690
US
Oracle version 11G.

How can I get the sessiontimezone variable to default or be the same as the bdtimezone. I need this at the database level not the client level.

Right now our bdtimezone shows 'America/Chicago', but our sessiontimezone shows '-5'.

Thank you,
Jerry
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
171
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
195
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
140
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
How to list all the CPU (EBS) patches applied - Oracle 11.2.0.4.
Replies
3
Views
143
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
374
carp
carp

Part and Inventory Search

Sponsor

Back
Top