MySQL Forums
Forum List  »  Newbie

Re: creating a table
Posted by: nhunt
Date: June 04, 2005 05:50AM

Hi Abyss

Not sure if this will work, haven't tested the syntax myself, but you could try using the CURTIME() function for the default value for the field....so:

RegistrationDate DATETIME DEFAULT CURTIME()


see how it goes

Options: ReplyQuote


Subject
Written By
Posted
June 03, 2005 06:54PM
Re: creating a table
June 04, 2005 05:50AM
June 06, 2005 04:53AM
June 06, 2005 05:08PM


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.