Re: globals besides relvars?
Date: 28 Jul 2003 10:01:32 -0700
>> 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 - 19:01:32 CEST