Netezza – How GET to Database UTC Offset With SQL
Netezza Database Timezone Offset
Recently, I reason to know the Coordinated Universal Time (UTC) Time zone offset of the Netezza database for incorporation into an ETL. So, here is an easy Aginity Workbench SQL to pull Time Zone information from your database, if you have permission to the _VT_PG_TIME_OFFSET view.
UTC Time Zone Offset SQL
SELECT (select EPOCH
from _VT_PG_TIME_OFFSET) as “EPOCH “
,(select ONE_MICRO
from _VT_PG_TIME_OFFSET) as “ONE_MICRO”
,(select TZOFFSET
from _VT_PG_TIME_OFFSET) as “TZOFFSET”
,(select TZNAME
from _VT_PG_TIME_OFFSET) as “TZNAME”
FROM _V_dual
Limit 1;
5 thoughts on “Netezza – How GET to Database UTC Offset With SQL”