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.
