Problems with setting cuurent date

Anon

I have a table with two columns of timestamp(14) data. One of them is storing the exact time of reporting a problem, the other one is supposed to hold a exact date/time of fixing the problem. When I insert a new problm to the table, I use:

insert into table(report_time,fix_time) values (null,'00000000000000')

It works pretty well. When an administrator fixes the problem I wanted to update the fix_time column with NULL value (it is supposed to get the exact system time). That's fine, but it also changed the report_time. How can I avoid this? Help me please? Or is the basic concept bad?

Thanks, Akos

Anon

If you are using MySQL and try to insert into a table with a timestamp field it will update the first timestamp with the system time.

You should make your second statement only affect the second column.

table: field1 timestamp, field2 timestamp

Insert into table(null, 0000000000);
Update table set field2=NULL;

Something like this should work, or if NULL doesn't read to the current time use the function NOW() which will put in the current time.

Anon

Use this..

UPDATE your_table SET report_time=report_time, fixed_time = NOW();

It'll leave the report time alone, so it's not automatically updated and update the fixed time to the currect system time. I think you can use NULL, but this way you know it works...

---John Holmes...