What is the SQL statement (Oracle) for modifying a column in DATE using SYSDATE by default?

Question

I got the table name: kundorder

And the column name: datum . I want to change the data type to (DATE, SYSDATE), but I cannot get it to work.

Answer 1

I think it should look like this.

 ALTER TABLE kundorder MODIFY datum DATE DEFAULT SYSDATE 

So you are saying that datum should be of type date , but if that is already the case, of course,

 ALTER TABLE kundorder MODIFY datum DEFAULT SYSDATE 

also works by letting the datum field type do the same as the default - SYSDATE.