I have an issue while trying to query the bizdoc table from the webmethods TN schema.
My problem is the display of “doctimestamp” record : I typically use the following query
select to_char (DOCTIMESTAMP,‘YYYY/MM/DD HH24:MI:SS.FF’) as DOCTIMESTAMP from bizdoc where DOCID=‘54cfpp008peddb2400000iti’
The issue here is that it display me the UTC time which is not my exact timezone (depends of winter time UTC+1 or UTC+2).
Is there a possibility to retrieve the good display of this record ?
result of the query : 2014/06/02 14:16:12.725
a simple select sysdate from dual at the same time : 2014/06/02 16:16:12.725