Mutable
When run with a given set of arguments, mutable functions may not always produce the same result. Differing results can occur because of the database environment or session settings, such as locale. For example, a function that utilizes a timezone element. In one locale (New York) you would get x
for z
time query, whereas the same z
time query in another locale (Los Angeles) may return (x
- 3 hours) a different value.