oracle 12c forms taking timezone -5:30

0
votes

I have oracle 12c WebLogic and Oracle 12c Database installed on my windows server. On my database dbtimezone is giving me +00:00 which I want but on my forms builder when I'm running forms it taking -5:50 time.

Like if I enter 16:30 time on DateTime field then on the forms field it auto takes 10:00 automatically which means it's converting to -5:30.

As earlier, my timezone of the database was also -5:30 but then I changed my time zone to +00:00 So on database timezone is showing correct but oracle forms timezone is still not correct.

Any help would be appreciated.

2
oracleoracle12cweblogic12coracleforms
What are your server's timezone settings ? - krokodilko
my server timezone settings are (UTC +5:30) India timezone. - Deepak.Pal
Ok,thank you for checking this. And now please run within your WebLogic server this simple program, and retrieve it's output from the log: TimeZone tz = TimeZone.getDefault(); System.out.println( String.format("Time zone=%s, raw offset = %s, daylight savings = %s ", tz.getDisplayName(), tz.getRawOffset(), tz.useDaylightTime() )); This will tell you what timezone settings are configured on the server (jdbc driver borrows these settings from server's JVM). - krokodilko
DBTIMEZONE not not relevant for any display value, it is just the internal timezone of TIMESTAMP WITH LOCAL TIME ZONE data types, see stackoverflow.com/questions/29271224/… - Wernfried Domscheit
The problem occurring at the time when Oracle form runs as it converts the DateTime field to time zone -5:30 like if I type 16:00 then as soon as I go to next field it changes to 10:30 time. This problem is in oracle forms 12c. - Deepak.Pal

2 Answers

3
votes

You need to add in your forms environment file the following line:

FORMS_DATETIME_LOCAL_TZ=GMT

0
votes

After Adding NLS_DATE_FORMAT=DD-MM-YYYY in the registry for both Oracle DB and Oracle form services and altering the dbtimezone worked for me.

For altering the dbtimezone I referred this link.