Time Converter Script for Oracle APEX

  declarev_valueGMT1 number;v_valueGMT2 number;v_valueGMT3 varchar2(20); v_valueIST1 number;v_valueIST2 number;v_valueIST3 varchar2(20);v_sysdate date; beginselect sysdate into v_sysdate from dual; if :P2_SELECT_ZONE = ‘IST’ thenv_valueGMT1:=to_number(substr(:P2_TIME,0,2));v_valueGMT2:=to_number(substr(:P2_TIME,4,5));if v_valueGMT1 > 5 thenv_valueGMT1:=v_valueGMT1-5;elsif v_valueGMT1=5 thenv_valueGMT1:=’00’;elsev_valueGMT1:=24-(5-v_valueGMT1);v_sysdate:=v_sysdate-1;end if;if v_valueGMT2 > 30 thenv_valueGMT2:=v_valueGMT2-30;elsif v_valueGMT2 = 30 thenv_valueGMT2:=00;elsev_valueGMT2:=60-(30-v_valueGMT2);end if;if v_valueGMT1 < 10 and v_valueGMT2 <10 thenv_valueGMT3:=’GMT’||’ 0’||v_valueGMT1||’:0’||v_valueGMT2||’ ‘||v_sysdate;elsif v_valueGMT1 < 10 and v_valueGMT2 > 10 thenv_valueGMT3:=’GMT’||’ 0’||v_valueGMT1||’:’||v_valueGMT2||’ Read more about Time Converter Script for Oracle APEX[…]