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?
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.
HELP SESSION will display the current session time zone offset interval (hours/minutes).
See also the documentation for the system-defined GetTimeZoneOffset UDF.