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

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

    adOraDev

      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