Archives of the TeradataForum
Message Posted: Thu, 17 Oct 2013 @ 17:15:24 GMT
More likely, you just had a zero time zone offset on prior release and nonzero in TD14.0.
In case 1, CURRENT_TIME (which is a TIME WITH TIME ZONE) is first converted to UTC (GMT) using its included time zone offset (which currently reflects 1 hour daylight saving adjustment), then the session / user / system time zone (without any daylight saving adjustment) is applied to give the result.
Perhaps not the result you expect, but working as designed.
In case 2, all times are effectively converted to TIMESTAMP using CURRENT_DATE, then normalized to UTC/GMT using the included TIME ZONE for CURRENT_TIME and the session / user / system time zone offset for the CASTs (again without any daylight saving adjustment), and the timestamps compared.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|