Toad World® Forums

Edit date problem


#1

Hi

Please try this

create table a as (select to_date(‘31-12-1008’,‘DD-MM-YYYY’) a from dual)

(edit on)
select * from a

try to edit the field
I got the above symbols (no calendar opened)

Regards
Filipe
OptimizerEngine.exe.mdmp (56 KB)


#2

Hi Filipe,

Unfortunately, SQL Navigator can handle dates only within a certain range. The lowest date value is 12/30/1899; below that, we have a problem. Of course, in this case we have to display some meaningful message instead of garbage. You definitely found a bug.

Thank you,
Roman