MySQL Forums
Forum List  »  Newbie

Insert Date (newbie)
Posted by: Chris Felder
Date: April 09, 2005 04:35PM

I know this is probably very basic but I've looked everywhere online to find the simple solution and no luck so far. I have a form submitted via ASP to a mySQL database. In the database, I have a field named DateSubmitted. I want the date the form is submitted to write to this field. I have the default value of the database set to Now(). When I submit the form as it is now, the date 1/1/0001 is being written to the field. How do I get it to write the current date? Do I need to revise the form somewhat to make this happen? Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Insert Date (newbie)
April 09, 2005 04:35PM
April 10, 2005 10:59PM
April 11, 2005 07:59AM
April 12, 2005 08:39AM


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.