How to Enable UTC using TimeDateWZControl cmd

Database
Enthusiast

How to Enable UTC using TimeDateWZControl cmd

I am not able to enable UTC for using below command 

"TimeDateWZControl is set to 2 (enable UTC)

2 REPLIES
Enthusiast

Re: How to Enable UTC using TimeDateWZControl cmd

You can do it 2 ways.

At system level

 You might need to change the setting for the DBS Control flag TimeDateWZControl.


At Session Level

SET TIME ZONE 'GMT+5:30'   ( This is India Time zone where they don't use Daylight savings and the time '2009-03-08 02:01:05' is a valid time there)

run the update SQL, you should see the data as you expected.

If you want to check the allowed time zone strings please refer to below link.

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/End_...





I am not able to  system level Setting  (set TimeDateWZControl)

Teradata Employee

Re: How to Enable UTC using TimeDateWZControl cmd

Not sure what you mean by "enable" UTC. You can certainly play with TimeDateWZControl setting on a TD Express VM; but please contact Teradata support for assistance before changing this value on a live system.