Archives of the TeradataForum

Message Posted: Thu, 17 Oct 2013 @ 17:15:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>