create timestamp
I am trying to create a statement which will populate a timestamp cell. I need to take the current date, add a day then add a specific time. I have tried the following statment but have had no luck. Any suggestions?
update tags.triggers set next_time_of_day=str_to_date(adddate(current_date(),1) 11:12:12 %Y-%m-%d %H:%i:%s) where id=1;
Subject
Written By
Posted
create timestamp
May 06, 2005 03:10PM
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.