MySQL Forums
Forum List  »  Newbie

Auto Add Date like TIMESTAMP
Posted by: Jon Rios
Date: August 08, 2017 09:04AM

i know i can use the TIMESTAMP which will automatically insert a date&time as a value in a column.

Can i just do a Date? if possible, what would be proper syntax?

alter table revisions
ADD COLUMN test TIMESTAMP;

Options: ReplyQuote


Subject
Written By
Posted
Auto Add Date like TIMESTAMP
August 08, 2017 09:04AM
August 08, 2017 10:03AM


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.