I am updating a column in a table through SQL+ using
Select to_char(systimestamp,'YYYY/MM/DD-HH24:MI:SS.FF3')from dual;
The same field when updated through an application has a time offset of 4hrs.
Select dbtimezone from dual;
I want to form a statement which will update the field with the time offset as done through the appln. Please help.