Home » SQL & PL/SQL » SQL & PL/SQL » session time zone
session time zone [message #225691] Wed, 21 March 2007 00:26 Go to next message
karismapanda
Messages: 58
Registered: January 2007
Member
Hi,
I have altered the dbtimezone to gmt.I haven't altered the session time zone.But dbtimezone and session timezones are giving me different values.can any one please explain me the reason.I am working directly on the server.
Thanks,
karisma
Re: session time zone [message #225705 is a reply to message #225691] Wed, 21 March 2007 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

dbtimezone is the time zone of your database that is the time zone of all timestamp data without any time zone and the time zone to/from which the database converts timestamp with local time zone data.
When you alter the db time zone, then you says my database is working in this time zone. DB time zone may not be related to your real time zone. It is your choice, you can have your database in India and says that it is working in NY for convenience purpose.

sessiontimezone is the time zone of your session which derived from your OS time zone, environment parameters or an "alter session".

Regards
Michel
Re: session time zone [message #225707 is a reply to message #225705] Wed, 21 March 2007 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In addition: If you use the default, db time zone is fixed, session time zone changes with DST date.

Regards
Michel
Re: session time zone [message #225766 is a reply to message #225707] Wed, 21 March 2007 06:13 Go to previous message
karismapanda
Messages: 58
Registered: January 2007
Member
Thanks
Previous Topic: HOW TO CALL PROCEDURE FROM ANOTHER TO INSERT VALUES INTO A TABLE.....
Next Topic: Saving XMLTYPE data to server
Goto Forum:
  


Current Time: Tue Dec 06 16:16:30 CST 2016

Total time taken to generate the page: 0.08569 seconds