1 Reply Latest reply on Jul 7, 2013 6:28 PM by lake Branched from an earlier discussion.

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


      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.