I have same settings, despite that primary language is set to Swedish.
but the Time in the Database are correct. You have UTC Time in the Database. That is why you get that 07+02 = 09.
if you remove the +02, than is the Time in the Diagram Wrong.
Do you want to remove that 02?
I'm having problem with Gantt graph in APEX 18.1.
The Date in database is 07:02 but in the Gantt graph that time is moved to 09:02. Have tried to use both DATE and TSZ without success. If using SYS_EXTRACT_UTC I get 'Invalid data' in the Gantt graph.
It could be some UTC related conversion taking place which is +2 hours now, but I can't figure out the best approach to handle the situation.
If the time is 07:02 in the database it should be 07:02 in the Gantt graph too.
How do I approach this problem?
- Provide full details of your environment (including the DBTIMEZONE) and describe the steps required to reproduce the problem. Create a demonstration on apex.oracle.com.
Similar issues have been reported before, without any clear indication that Oracle has definitively resolved the problem or provided information on how developers can avoid it:
- APEX 5.1.1, JET Charts, how to create a dynamic line chart (or scatter chart with lines)
- Oracle Jet Timestamp: timeshift bug
- Oracle JET TimeStamp ?
- The APEX JET Charts handle time zones differently in Safari versus other browsers.
Hilary Farrell-Oracle: Is this still occurring in 18.1 or is it a different issue?
This problem is new to me in APEX 18. I did a few Flash based Gantt graphs previously, but I have never seen this problem before.
From my earlier experience I have duplicated the datatypes for the dates. Therefore I can easy switch between the two datatypes.
The outcome is the same. Time is moved +2 tim.
All involved servers and clients are setup with localisation EN-US. The only Sweish involved is the keyboard, and in this case the Application Primary Languiage set to Swedish (sv) in APEX (It is usually set to US-English).
Gantt table data.JPG 47.1 K
DBTIMEZONE says +02:00