Hello
How can i set the time zone in an application so that it renders the correct time when inserting/updating a database. For some reason it is some times correct and other times it is incorrect. I am think due to daily savings time and or the time zone is not set right through apex. I only have one time zone to use but it does not render correctly 100% of the time in the database.
DECLARE
BEGIN
UPDATE CONTRACT_TIMEKEEPER T
SET T.TIME_OUT = LOCALTIMESTAMP, -- to_timestamp(LOCALTIMESTAMP,'YYYY-MM-DD HH:MI PM')
T.TIME_OUT_UTC = LOCALTIMESTAMP
WHERE T.WORK_DATE = :P3_TODAY
AND T.CONT_ID = :P5_CONT_ID
AND T.POSITION = :P3_POSITION
AND T.TIME_OUT IS NULL
AND T.SCH_ASSIGNED = :P3_SCH;
END;