Schema Browser shows the system date in a table column named CURRENT

Chat now with support

Schema Browser shows the system date in a table column named CURRENT_DATE (4334287)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Schema Browser shows the system date in a table column named CURRENT_DATE
Description

Schema Browser shows the system date in a table column named CURRENT_DATE

Steps to reproduce the problem:

1.Create a table with a column name CURRENT_DATE:
CREATE TABLE test_current_date
(
CAMPO2 VARCHAR2(10 BYTE),
CURRENT_DATE DATE
)
2. Enter one record:
,
INSERT INTO TEST_CURRENT_DATE (
CAMPO2, CURRENT_DATE)
VALUES ('a',
to_date( '01/01/2000','DD/MM/YYYY'));
commit;
,
3. Go to the Schema Browser:
,
In the column current_date you will see the system date instead of the date entered before.
If you go to the Editor and run
select * from test_current_date, then toad shows you the date you entered instead of the system date.
SQL Plus also shows the correct date.
Resolution

WORKAROUND

Run the query in the SQL Editor

STATUS

Waiting for a fix in next release of Toad For Oracle
Defect ID

ST82626

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Schema Browser shows the system date in a table column named CURRENT_DATE (4334287)