TIMEZONEBN_TMZN_EDITVW(SQL View) |
Index Back |
|---|---|
Time Zone Values viewThe valid server time zones are stored in the TIMEZONESTDLBL (standard timezones) and TIMEZONEDSTLBL (daylight savings timezones) fields on the PSTIMEZONE table. A UNION is n |
| SELECT DISTINCT CASE WHEN A.FIELDNAME = 'TIMEZONESTDLBL' THEN B.TIMEZONESTDLBL ELSE C.TIMEZONEDSTLBL END , CASE WHEN A.FIELDNAME = 'TIMEZONESTDLBL' THEN B.TZDESCR ELSE 'DST ' %Concat %TrimSubstr(C.TZDESCR , 1 , 46) END FROM PSDBFIELD A , PSTIMEZONE B , PSTIMEZONE C WHERE A.FIELDNAME IN ('TIMEZONESTDLBL', 'TIMEZONEDSTLBL') AND B.TIMEZONESTDLBL <> ' ' AND C.TIMEZONEDSTLBL <> ' ' AND NOT EXISTS ( SELECT 'X' FROM PSTIMEZONE C1 WHERE C1.TIMEZONESTDLBL = C.TIMEZONEDSTLBL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIMEZONE |
Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 2 | TZDESCR | Character(50) | VARCHAR2(50) NOT NULL | Time Zone Description |