Kintana Script : Oracle DB Timezone Version

Purpose

You need to ensure that the Oracle database has the time zone files updated to version 3 (US).

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

-- Oracle 10g

select version from v$timezone_file

-- Oracle 9i

select case COUNT(DISTINCT(tzname))
when 183 then 1
when 355 then 1
when 347 then 1
when 377 then 2
when 186 then case COUNT(tzname) when 636 then 2 when 626 then 3 else 0 end
when 185 then 3
when 386 then 3
when 387 then case COUNT(tzname) when 1438 then 3 else 0 end
when 391 then case COUNT(tzname) when 1457 then 4 else 0 end
when 392 then case COUNT(tzname) when 1458 then 4 else 0 end
when 188 then case COUNT(tzname) when 637 then 4 else 0 end
when 189 then case COUNT(tzname) when 638 then 4 else 0 end
else 0 end VERSION
from v$timezone_names;

Download

KintanaScripts.zip (64 Kb)