This discussion is archived
2 Replies Latest reply: Aug 22, 2013 12:31 AM by Dev. Musbah RSS

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

Dev. Musbah Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points