Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: globals besides relvars?

Re: globals besides relvars?

From: --CELKO-- <joe.celko_at_northface.edu>
Date: 28 Jul 2003 10:01:32 -0700
Message-ID: <a264e7ea.0307280901.131b4dd1@posting.google.com>


>> So what if you have some function that requires some storage? For
example, imagine a function that returns the current timezone. It needs to store this somewhere. Presumably there's a setTimeZone function also. Where does it store the timezone? <<

In SQL-92, there are schema information tables that hold the metadata for the schema. One of these tables is the timezone information that holds the displacments from UTC for the local lawful time (that is the term for DST and the zone combined by law) in the timezones. Someone with System Admin privileges can update these values as needed. But the actual time in the system is always UTC; local time is a display feature. Received on Mon Jul 28 2003 - 12:01:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US