This content has been marked as final. Show 2 replies
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