2 Replies Latest reply: Aug 22, 2013 2:31 AM by Dev. Musbah RSS

    How to import a datetime format from excel 2010 file to the Form?

    Dev. Musbah

      Hi All,

      I've an excel 2010 file which has a column with format cell Custom dd/mm/yyyy hh:mm

      I'm trying to retrieve its data in a date database item  with format mask dd/mm/yyyy hh24:mi like this:

      cell_value_date := to_date('01/01/1900', 'DD/Mm/YYYY HH24:MI') + ole2.get_num_property(cell, 'Value') -2 ; -- cell_value_date varchar2(4000) declared variable

      but when the data returned it appeared without time like this: 03/07/2013 00:00

      How to solve this problem please?

       

      Note: I'm using DB 10g, Forms 6i

      Thank you