When selecting data from a table with an oracle type the format is wrongly displayed in the grid but when double clicking the field it's displayed correctly.
To reproduce the issue run the script below:
CREATE OR REPLACE TYPE reg_data_obj
AS OBJECT
(USER$ VARCHAR2(20)
,REG_DATE date
,MANUAL_DATE date
,TERMINAL VARCHAR2(12)
,
--
constructor function reg_data_obj
return self as result,
constructor function reg_data_obj (
i_terminal in varchar2
) return self as result
)
/
CREATE TABLE date_bug
(
A_DATE DATE NOT NULL,
REG_BACK reg_data_obj DEFAULT reg_data_obj(NULL,NULL,NULL,NULL)
)
/
select * from date_bug;
insert into date_bug
values(sysdate, reg_data_obj(null,sysdate,null,null));
commit;
select * from date_bug;
the last select shows
25/09/2015 19:57:30
SOO.REG_DATA_OBJ(NULL,TO_DATE('09/25/2015 19:57:30', 'MM/DD/YYYY HH24:MI:SS'),NULL,NULL)
sql plus shows
25-SEP-15
REG_DATA_OBJ(NULL, '25-SEP-15', NULL, NULL)
when you double click on the reg you see the date without the to_date oracle function
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center