You do not need to set a default value if you want the current_timestamp.
Just leave the default option out when creating your table and the server
will do it for you.
CREATE TABLE COOKIE_REF (
cookie_ref varchar(50),
dat timestamp
);
OR
If you really want to put in a va
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 06/07/2005 04:29:56 PM:
> Hello,
> I am trying to create simple reference table for some cookies I am
> creating. I wanted to put in a current_timestamp each time I do an
> insert so I can delete this data after 2 or 3 weeks.
> Here is the insert sta
