MySQL Forums
Forum List  »  Newbie

create timestamp
Posted by: JOHN FARRUGIA
Date: May 06, 2005 03:10PM

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;

Options: ReplyQuote


Subject
Written By
Posted
create timestamp
May 06, 2005 03:10PM
May 06, 2005 06:55PM


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.