1 Reply Latest reply on Aug 11, 2015 2:06 PM by Jon-Marcelius Potian

    Unable to fetch timestamp through query from the date&time field of oracle11g of arsystem

      Share This:

      need to query the database having date/time field as the condition . but date/time is stored in 10 digit integer form in oracle 11g .


      Please help me with the oracle 11g query which can fetch the date/time in the time stamp format as it is stored in 10 digit integer form .


      and educate me on what form oracle is storing the time stamp in the back end .


      Regards Roopa