Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: CAST(CURRENT_TIME AS TIME) reporting wrong time in TD 14.0
From:   Pluebell, Fred

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023