Member Avatar for dinilkarun

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

  • 3 Contributors
  • 2 Replies
  • 121 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by hfx642
Member Avatar for debasisdas

Need more information on the exact issue.

Member Avatar for hfx642

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.