CREATE OR REPLACE FUNCTION MSPDS.TO_MSPDS_TIME_TZ (
    v_time    TIMESTAMP WITH TIME ZONE)
    RETURN TIMESTAMP WITH TIME ZONE
IS
BEGIN
    RETURN v_time;
END;



CREATE OR REPLACE FUNCTION MSPDS.TO_MSPDS_TIME_T (v_time TIMESTAMP)
    RETURN TIMESTAMP WITH TIME ZONE
IS
BEGIN
    RETURN FROM_TZ (v_time, 'US/Pacific');
END;



CREATE OR REPLACE FUNCTION MSPDS.TO_MSPDS_TIME_D (v_time DATE)
    RETURN TIMESTAMP WITH TIME ZONE
IS
BEGIN
    RETURN FROM_TZ (v_time, 'US/Pacific');
END;


CREATE OR REPLACE OPERATOR TO_MSPDS_TIME BINDING
    (TIMESTAMP WITH TIME ZONE)
        RETURN TIMESTAMP WITH TIME ZONE
        USING TO_MSPDS_TIME_TZ,
    (TIMESTAMP)
        RETURN TIMESTAMP WITH TIME ZONE
        USING TO_MSPDS_TIME_T,
    (DATE)
        RETURN TIMESTAMP WITH TIME ZONE
        USING TO_MSPDS_TIME_D;