0
I have a script in oracle that inside a table called "move" there is a column called "dt_move" and inside this column there is the DATE value i would like to change this value to the date of the system with the alter table more can not
I’m using
ALTER TABLE tb_motion Modify (dt_sysdate drive) AND DOES NOT WORK
someone knows how I solve this poblema
Try:
ALTER TABLE tb_movimentaçao MODIFY (dt_movimentaçao DEFAULT SYSDATE), then the records included in the table will contain the date of the system at the time of inclusion. If that’s not what you want to explain better.– anonimo
DATE is a type , a data type. SYSDATE is an operator that returns the current date and time of the Server.
– Motta