formatting PostgreSQL timestamp type

[pablogosse]

Hi all. I've got the following table structure:

CREATE TABLE unbc_users (
user_id serial,
firstname varchar(255) ,
lastname varchar(255) ,
username varchar(25) UNIQUE,
password varchar(25) ,
email varchar(255) UNIQUE,
hint integer ,
answer varchar(255) ,
status integer ,
added timestamp(13) default now()
);

however when ever a record is inserted, the timestamp is set as follows:

2002-10-07 09:16:51.158068-07

How can I set it up such that the timestamp is only to the seconds? I've tried lowering the length of the timestamp field but it always enters the same.

Thanks in advance,

Pablo

[Sxooter]

yeah, create your timestamp as a timestamp(0)

[csn]

to_char()

[pablogosse]

Found the problem. I hadn't specified "without time zone" in my create table statement. Did that and it worked fine.

Thanks all.

P.