PSTIMEZONELANG

(SQL View)
 Index Back

Time Zone Data


SELECT A.TIMEZONE , LANGUAGE_CD , TIMEZONESTDLBL , TIMEZONEDSTLBL , TZDESCR FROM PSTIMEZONEDFNLG A JOIN ( SELECT TIMEZONE , MAX(PTEFFDTTM) PTEFFDTTM FROM PSTIMEZONEDFNLG WHERE PTEFFDTTM< %CurrentDateTimeIn GROUP BY TIMEZONE) B ON A.TIMEZONE = B.TIMEZONE AND A.PTEFFDTTM = B.PTEFFDTTM

  • Related Language Record for PSTIMEZONE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 TIMEZONESTDLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Standard Label
    4 TIMEZONEDSTLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Daylight Label
    5 TZDESCR Character(50) VARCHAR2(50) NOT NULL Time Zone Description