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 NameField TypeColumn TypeDescription
    TIMEZONECharacter(9)VARCHAR2(9) NOT NULLTime Zone
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    TIMEZONESTDLBLCharacter(8)VARCHAR2(8) NOT NULLTime Zone Standard Label
    TIMEZONEDSTLBLCharacter(8)VARCHAR2(8) NOT NULLTime Zone Daylight Label
    TZDESCRCharacter(50)VARCHAR2(50) NOT NULLTime Zone Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19