Home > mailing lists

Inserting a timestamp in a "timestamp" column. - Mailing list pgsql-general

From	rihad
Subject	Inserting a timestamp in a "timestamp" column.
Date	September 14, 2007 20:25:48
Msg-id	46EAEDD3.3090407@mail.ru Whole thread Raw
Responses	Re: Inserting a timestamp in a "timestamp" column. (Erik Jones <erik@myemma.com>)
List	pgsql-general

Tree view

Hi all,

I have a column declared as "timestamp without time zone" that I vainly
want to insert a raw timestamp into (i.e. in the format returned by
Perl's or PHP's time()). I know of SQL NOW(), but I want to insert a
"cooked" timestamp from the outside most efficiently. How?

Thanks.

pgsql-general by date:

From: Oleg Bartunov
Date: 14 September 2007, 20:01:11
Subject: Re: tsearch2 and parsing host strings

From: "Pavel Stehule"
Date: 14 September 2007, 20:32:45
Subject: Re: plpgsql trigger original query

Inserting a timestamp in a "timestamp" column. - Mailing list pgsql-general

Previous

Next