Hello All there,

I am looking for defining default value for a DATETIME column in MYSQL. As I read from the online manual, it says that, the defaul values for a column while creating a table, should always be constant, something like NOW() or CURRENT_TIME cannot be given. But is there a way to have the current date/timestamp stored in to the table in the way of defining DEFAULT VALUE everytime a record is inserted to the table.

Thanks for the help in advance.

Regards,
Vijay G

__________________
- Vijay G

Hi,
There is no way to insert current date or time in MySQL while creating tables.U have to insert the values urself. I way not got anyway. I have tries different queries to insert into the table current date or time.
thanx

Timestamp fields default to the current time for UPDATE and INSERT queries, but not DATE or DATETIME fields. If you need this added convenience, use a timestamp field.

Read up on the different types here:
  http://www.mysql.com/doc/en/DATETIME.html


Take care,

Nik
http://www.bigaction.org/

You may use 'getdate()' as a default value for datetime columns in SQL Server.

That doesn't help much as this is a MySQL forum, though.. =(

Take care,

Nik
http://www.bigaction.org/

Thanks! Using the timestamp field worked great for capturing the date/time of the insert event.