Re: Timestamp not working

CREATE TABLE mytable (

id serial not null primary key,

myvalue varchar(50),

create_dt timestamp not null default now()

);

INSERT INTO mytable (myvalue) VALUES ('When was this record inserted ?');
SELECT * FROM mytable;

"Si" <si(at)hotmail(dot)com> wrote in message
news:88odf(dot)2261$fN5(dot)887(at)newsfe6-gui(dot)ntli(dot)net(dot)(dot)(dot)
>I have added a field to one of my PostgreSQL tables in the "Timestamp"
>datatype, but when I add a row to that table I don't get the date and time
>inserted into that column? Do I need to put a default value into the column
>too?
>