I am raising this on behalf of Fairfax Media.
This is an issue with the Database Configuration procedures in the Getting Started Guide
The optional part of step 5 of the "Configuring Teradata Database" section of the guide allows you to set the timezone for the instance - important in the Sydney (Australia) Region.
Type the time zone only:
We ran this optional component in the setup. However, the timezone in Teradata still does not display the correct timezone when you run a "Select timestamp()" - I think that's the right syntax.
It shows the timezone is still UTC - "00". Can't remember the exact syntax and output (I am offsite).
Could you please update with below information ?
1) cat /etc/sysconfig/clock
2) ls -ltr /etc/localtime
3) date and date -u output
4) login through any user and run below query,
5) Please provide DBSControl general settings, You can make use of below command.
:~# dbscontrol -g | egrep 'TimeZone|TimeDateWZControl'
I believe database time zone isn't set via DBSControl settings and thus, "00:00" time zone offset is being displayed for CURRENT_TIMESTAMP.