Archives of the TeradataForum
Message Posted: Mon, 25 Jun 2007 @ 09:26:04 GMT
The CURRENT_TIME and CURRENT_TIMESTAMP do not display the time value in the local time zone, as they should do.
set time zone interval -'08:00' hour to minute; sel current_timestamp;
Now, change the local time zone.
set time zone interval '00:00' hour to minute; sel current_timestamp;
My changed time zone is reflected in output, but the time is still the same (ignore the fractional secs) ?? Should it not be adjusted to be in my local time zone? Something like
I ran the above on Teradata Demo.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|