Thanks for the help. With some "encouragement" from management, the developers have decided to change the two functions that are having the problem to use the TZ_OFFSET(DBTIMEZONE) that Bradd suggested. Sandy