This discussion is archived
1 Reply Latest reply: Jul 7, 2013 11:28 AM by lake Branched from an earlier discussion. RSS

Re: Oracle Forms New Features - Your input.  Supporting data types

adOraDev Newbie
Currently Being Moderated

Hi Michael,

 

I came across your reply whilst searching for an answer to my issue in oracle forms.

I use oracle forms 10g and oracle 11g.

I have a column of type timestamp with local timezone where I insert the timestamp in my local time zone. I cannot display this value in forms.

The datetime item will display this value in GMT(which i guess is the server timezone) whilst selecting the value in DB shows the correct timezone EST.

Is there any way to workaround this in forms. I tried cast and to_timestamp_tz but maybe I'm not proficient but that didnt work.

You have any inputs on this, Please do let me know.

 

Thanks,

Adarsh