dbtimezone in teradata

Database

dbtimezone in teradata

Hi,

How do we get the timezone of the database in teradata?

Similar to select dbtimezone from dual in oracle

Ajay

1 REPLY

Re: dbtimezone in teradata

If you mean 'database' as 'user', you can

SELECT TimeZoneHour, TimeZoneMinute FROM DBC.USERS;

If you mean 'database' as 'system' you can:

dbscontrol -> DILPLAY GENERAL ->  System TimeZone Hour,  System TimeZone Minute.

HTH.

Cheers.

Carlos.