I am based in Sydney, Australia and have the database with APEX runing here and Database timezone set to AEST (Australian Eastern Standard Time).
Now, In one of the fields in my form, which links to a timestamp with local timezone column, 23/11/2010 (23rd November 2010) comes up as 22/11/2010, a day earlier when page is rendered.
If I query that particular row, I get the correct value in SQL developer and SQL Plus.
I have set Automatic Timezone on for the application which was supposed to extract users timezone in browser but no luck.
Anyone ran into this problem? Any suggestions appreciated.
Oracle Database 11GR2
Did you read this?
(YABAOAE) Yet Another Blog About Oracle Application Express: Automatic Time Zone support in Application Express