SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

displaying Null-date in SQL developer

f.philipOct 12 2007 — edited Oct 17 2007

Hi,

I run into the following problem (with SQL developer Vers. 1.2.0 build 2998).
On a table with a date column and a null date in some rows (the default value is "to_date(1, 'J')" ), SQL developer is showing after a query in the SQL worksheet the date "01/01/4713"
However, when I'm executing the same query in SQL*Plus, the columns with a null-date showing the value "01/01/4712"

How is it possible that SQL-Developer and SQL*Plus showing different dates on the same data?

Any suggestion or explanations for this behavior?

Any help is much appreciated.

TIA

Fred

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2007

Added on Oct 12 2007

#sql-developer

4 comments

3,514 views