4 Replies Latest reply on Feb 23, 2014 4:12 PM by rp0428

    Bug? Cannot change default value for date column to sysdate+1/24




      I have SQL Developer Version
      I'm working with Oracle Database 11g Enterprise Edition Release - 64bit Production


      For the following table:


      create table delete_me(d date);


      I cannot change default value via interface:Right click on table -> Edit -> Columns -> Set default value to sysdate+1/24 results in error "Invalid expression "sysdate+1/24". Expeced a DATE or TIMESTAMP expression"

      But this expression is correct and the following works fine:


      alter table delete_me modify(d date default sysdate+1/24);