Timestamp in database for new row

Question

I have a timestamp field in my db.
In my mysql program I clicked on the box that says "On Updated Current_Timestamp" which works fine for updating rows in the database and adds the time.
Now I want it to add the time for NEW rows, so in the default box I put now(); but I get an sql error. I am doing it in the database to lessen the load on coldfusion but maybe something like this is better in my cfquery insert into sql?:

What do you think I should do? Thanks

Anonymous · Accepted Answer

It it is truly a timestamp field, there should be no need for a default value... no?

Thanka for all the input I played around a lot with it and I made it work, this is what I did to the timestamp mysql field:

Field length 0.

Decimals 0

Allow null NO

Checkbox for On Update Current_Timestamp selected

Default value CURRENT_TIMESTAMP

It now works fine adding/updating the date for both a new and an exisiting record automatically

Thanks for all the help about dates

Dan_Bracuk · Answer

What is the code you are running and what is the error?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded