Capturing System time and storing in mySQL while submitting a form in JSP
Posted on 2004-11-15
I developed a form in JSP. This form contains two fields, i.e. text box,text area . These are for entering news title and news description. When i submit the form the system time (submission time) has to be stored in the database. How can i achieve this in JSP?.
At the moment my mySQLl data model contains two columns, i.e. NewsTitle, NewsDescription. And what data type should i use for inserting time of submission in the database.
Please help me in this regard. A snippest of code would be helpful for capturing system time (time of news submission).