Knowing Teradata System TimeZone

Database
Enthusiast

Knowing Teradata System TimeZone

How do I know what is the timezone to which the Teradata Server time is set to?

Also where do we store the valid timezone values?Is there any sytem metadata table?

Tags (1)
2 REPLIES
Teradata Employee

Re: Knowing Teradata System TimeZone

The system timezone settings can be retrieved with the dbscontrol utility. Formatting and parsing of timezonestrings is controlled at the system level with the tdlocaledef utility. Refer to the utilities reference documentation volumes. Other TZ capabilities are described in the SQL functions reference.

Teradata Employee

Re: Knowing Teradata System TimeZone

HELP SESSION will display the current session time zone offset interval (hours/minutes).

See also the documentation for the system-defined GetTimeZoneOffset UDF.