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

    Working!

      Hello.

       

      I have SQL Developer Version 4.0.0.13
      I'm working with Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 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);