Advertisement

09.15.2008 at 04:59AM PDT, ID: 23731603 | Points: 250
[x]
Attachment Details

Default value NOW for timestamp

Asked by fonfi in Interbase / Firebird Database

Tags:

I have a Firebird database installed on Linux server. I want to alter one of the tables with new column "recordservertime" of type timestamp, and assign default value 'NOW', the code is below. The table is altered, the column is created, and it seems that it have default value set to 'NOW', but the problem is that any insert into this table updates column "recordservertime" in all rows, not only the inserted one. What I want to achieve is to have insert time of each of the rows. What am i doing wrong? Start Free Trial
1:
alter table record_data add recordservertime timestamp default 'NOW' not null;
 
 
[+][-]09.15.2008 at 11:12AM PDT, ID: 22481274

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.15.2008 at 12:51PM PDT, ID: 22482211

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.15.2008 at 01:52PM PDT, ID: 22482726

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.16.2008 at 02:34AM PDT, ID: 22486409

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.16.2008 at 02:37AM PDT, ID: 22486438

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.16.2008 at 07:46AM PDT, ID: 22488941

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628