Jump to content

Archived

This topic is now archived and is closed to further replies.

Eiolon

Multiple timestamps

Recommended Posts

Hello,

I am creating a help desk and would like it to stamp the date/time when a request is submitted and also a date/time when the request is completed.  How would I go about having two timestamps?  Here is what I have for my structure:

[code]create table requests (
id int not null primary key auto_increment,
employee varchar(50) not null,
category varchar(50) not null,
priority varchar(10) not null,
description text not null,
status varchar(10) not null default 'Open',
submitted timestamp not null default current_timestamp,
completed timestamp not null default current_timestamp,
technician varchar(50) not null
);[/code]

I get this error:

[quote]ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP
column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause[/quote]

How do I accomplish two timestamps?  Thanks!

Share this post


Link to post
Share on other sites
Not sure... I'm sure there's a refman page on these crazy column attributes.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.