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
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