Netezza – How GET to Database UTC Offset With SQL

 

Netezza Database Timezone Offset

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;

Related References