the best way to insert default datetime
hi
i have to insert value into a table where it will always be the current time.
my column is of time datetime.
i thought to create a trigger like this:
CREATE TRIGGER insert_date BEFORE INSERT ON usercase FOR EACH ROW SET NEW.caseend = NOW();
what is better for performance: a trigger, or inserting the current date via the code?
thanks
Subject
Written By
Posted
the best way to insert default datetime
October 31, 2009 05:42PM
November 01, 2009 01:03AM
November 01, 2009 10:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.