Question: how to change date format in oracle forms?
Answer: AUDIT_OB_PREPARED_ON:=TO_date(to_char(SYSDATE, <default date format of session>),'DD-MM-RRRR HH24:MI:SS'); If AUDIT_OB_PREPARED_ON is a date (and it should be) then you should simply set it to sysdate. If it's a varchar then you should be using to_char not to_date.