System date capturing in to data base

Question

i create a registration form in my jsp project.mysql be the database.i want to insert system date automatically in datebase in the registration time.

Answer 1

Have a look at Date and Time functions of mysql. This may help you.

Answer 2

You can have a "date_created" field in a table, defined as

date_created timestamp not null default current_timestamp

When you perform an insert on the table ignoring this column, it will automatically be set to the current time of the mysql server.