Home > mailing lists

How to timestamp - Mailing list pgsql-general

From	Alex Cheung Tin Ka [CD]
Subject	How to timestamp
Date	December 27, 2001 06:56:17
Msg-id	00fa01c18eb3$6ffc4b20$6a44a8c0@ALEXPC Whole thread Raw
Responses	Re: How to timestamp
List	pgsql-general

Dear everybody,

I would like to know how to create a timestamp value without time zone.

I have encountered a problem that I have set following values in the table.

create table test(
a timestamp without time zone

);

INSERT INTO test (a) VALUES(current_timestamp);

but the value of a always shows the zone value like this "2001-12-27 14:54:47+08"

How to get rid of the last "+08" value?

Thanks,

Alex

From: rcaban@ccc-cable.net (roy cabaniss)
Date: 27 December 2001, 02:42:31
Subject: phplib and postgres

From: "Ben-Nes Michael"
Date: 27 December 2001, 12:42:49
Subject: persistent connection using PHP and Transaction