Could you try that basic sample so I see what is the result? First create that table: CREATE TABLE TB_TEST ( ID NUMBER(2, 0) NOT NULL, DATEFIELD DATE , CONSTRAINT TB_TEST_PK PRIMARY KEY ( ID ) ) Now, I insert a register: insert into tb_test values (1, sysdate) commit; And then, the select query: select (sysdate-datefield) from tb_test where id=1 What is the result?
Regards, Diego F.