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:|

      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

      9008554966