PSTIMEZONELANG

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 Field Type Column Type Description
    TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    TIMEZONESTDLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Standard Label
    TIMEZONEDSTLBL Character(8) VARCHAR2(8) NOT NULL Time Zone Daylight Label
    TZDESCR Character(50) VARCHAR2(50) NOT NULL Time Zone Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19