Hi All,

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;

returns

DBTIME
------
-04:00

I want to form a statement which will update the field with the time offset as done through the appln. Please help.

Regards,
Dinil

Need more information on the exact issue.

Member Avatar

Why are you not using SysDate instead of SysTimeStamp?
This MAY have something to do with it.
(I can't access my manuals, right now, to check.)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.