My application uses data-aware controls bound to database fields of type TIMESTAMP WITH LOCAL TIME ZONE.
When I READ data from the db, time values are displayed correctly i.e. in the Session Time Zone.
However, when I POST data to the db, time values are stored as if they were expressed in the Windows Time Zone
(set in the Windows Control Panel), which may differ from the Session Time Zone (set by ALTER SESSION statement in the application).
As a consequence, when the user modifies the minutes of a timestamp only and posts the changes,
the hours are changed as well.
Example:
Windows Time Zone = GMT + 2:00, Session Time Zone = GMT + 4:00
Database field contains time portion 13:00 GMT
Read from db -> data-aware control correctly displays 17:00
Edit control: change 17:00 into 17:10
Post -> database field contains 15:10 GMT and data-aware control displays 19:10
What should I do to make this work correctly?
Kind Regards,
Geert.