Archives of the TeradataForum

Message Posted: Mon, 25 Jun 2007 @ 09:26:04 GMT

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

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;

Output is

     2007-06-23 11:10:26.350000-08:00

Now, change the local time zone.

     set time zone interval '00:00' hour to minute;

     sel current_timestamp;

Output is

     2007-06-23 11:10:27.960000+00:00

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

     2007-06-23 19:10:27.960000+00:00

I ran the above on Teradata Demo.

Kumar

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