Teradata Studio TimeZone Setting Can not work

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Highlighted
Enthusiast

Teradata Studio TimeZone Setting Can not work

I tried to set TimeZone as 'Africa Egypt' when created a new user by Teradata Studio.

 

The SQL definition is OK.

 

TImeZone = 'Africa Egypt' 

 

But it is not worked.

 

Show the user definition,the TimeZone become  Null.

 

How to Solve this problem?

Please Help me.

Tags (3)

Accepted Solutions
Teradata Employee

Re: Teradata Studio TimeZone Setting Can not work

It seems that numeric TimeZoneHour, TimeZoneMinute (for fixed time zone offset with no "daylight saving" adjustments) are displayed in dbc.UsersV, but not TimeZoneString. Query dbc.dbase table directly and you will see the time zone information. Similarly if you log on as that user and do HELP SESSION or SELECT CURRENT_TIMESTAMP you should see that the time zone is actually in effect.

1 ACCEPTED SOLUTION
5 REPLIES 5
Enthusiast

Re: Teradata Studio TimeZone Setting Can not work

Modify User AS Time Zone='GMT'  is also not worked

Teradata Employee

Re: Teradata Studio TimeZone Setting Can not work

It seems that numeric TimeZoneHour, TimeZoneMinute (for fixed time zone offset with no "daylight saving" adjustments) are displayed in dbc.UsersV, but not TimeZoneString. Query dbc.dbase table directly and you will see the time zone information. Similarly if you log on as that user and do HELP SESSION or SELECT CURRENT_TIMESTAMP you should see that the time zone is actually in effect.

Teradata Employee

Re: Teradata Studio TimeZone Setting Can not work

Hi ,
It’s a known limitation with Studio , If you tried only the Studio to see the user definition which is showing NULL .
There are few changes need to be done from Studio to show the Time zone value in this case.
Which is interdependent on the DB Carnages as well. So this will be addressed in Future but it will take time.

 

Thanks for your patience and understanding.

Enthusiast

Re: Teradata Studio TimeZone Setting Can not work

Thank you very much.

Yes, it is actually in effect.

Enthusiast

Re: Teradata Studio TimeZone Setting Can not work

Thank you for you reply.

I have checked that it is really in effect, but can not confrim by the dba user.