What is the SQL statement (Oracle) to alter column to DATE with default SYSDATE ?

sql oracle

I think it should look like this

ALTER TABLE kundorder MODIFY datum DATE DEFAULT SYSDATE

That way you say that datum got to be of type date but if this is already the case of course

ALTER TABLE kundorder MODIFY datum DEFAULT SYSDATE

works also, letting the type of the field datum the same just making sure default is SYSDATE.

CodeHunter