Re: Timestamp not working - Mailing list pgsql-admin

From codeWarrior
Subject Re: Timestamp not working
Date
Msg-id dld0j2$h5u$1@news.hub.org
Whole thread Raw
List pgsql-admin
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@hotmail.com> wrote in message
news:88odf.2261$fN5.887@newsfe6-gui.ntli.net...
>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?
>





pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Major Problem, need help! Can't run our website!
Next
From: "Kevin Grittner"
Date:
Subject: Re: ERROR: could not read block