TIMESTAMP

[ledtear]

What is the recommended way to get a tiomestamp when a record is created, but that will not change when the record is edited? I just want to grab a time stamp when the record is created and have it never change.....

[laserlight]

Just store the timestamp and do not update it 🙂

[ledtear]

Hhmmm - thatn is what I am doing but it is still updating - perhaps it is that right now I am only working in the DB directly... maybe when the code starts doing the work that it will not do it - I'll keep an eye on it...

[laserlight]

ledtear wrote:

thatn is what I am doing but it is still updating

That is not possible. What is your SQL statement?

[Bjom]

Is this within a mySQL DB? And ist that happening "automatically" i.e. without PHP code?

Then this is what your column is set up like atm:

`yourCol` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP

And this is what you actually wanted:

`yourCol` timestamp NOT NULL default CURRENT_TIMESTAMP

And this is the SQL statement to fix it:

ALTER TABLE `yourTable` CHANGE `yourCol` `yourCol` timestamp NOT NULL default CURRENT_TIMESTAMP; 

Note that you need to repeat the field name.

regards

Bjom